Streaming API Developer Guide
jNotifyForFields Set to Select
When you set the value of PushTopic.NotifyForFields to Select, a change to any field value in the record, as long as that field is referenced in the query SELECT clause, causes the Streaming API matching logic to evaluate the record to determine whether to generate a notification.
If the PushTopic.NotifyForFields value is Select, the PushTopic query must have a SELECT clause with at least one field other than ID.
| Event | A notification is generated when |
|---|---|
| Record is created | The record field values match the values specified in the WHERE clause. |
| Record is updated |
The following conditions are met.
|
Examples
| PushTopic Query | Result |
|---|---|
| SELECT Id, f1, f2, f3 FROM Invoice_Statement__c | Generates a notification if f1, f2, or f3 have changed. |
| SELECT Id, f1, f2 FROM Invoice_Statement__c WHERE f3 = 'abc' AND f4 LIKE 'xyz' | Generates a notification if f1 or f2 have changed and f3 and f4 match the values in the WHERE clause. |
| SELECT Id, f1, f2 FROM Invoice_Statement__c WHERE Id IN ('a07B0000000KWZ7IAO', 'e10R0000000KEU9IAO', 'v32B0000000KWZ7YEP') | Generates a notification if f1 or f2 have changed and ID is contained in the WHERE clause IN list. |
| SELECT Id, f1, f2 FROM Invoice_Statement__c WHERE f3 = 'abc' AND f4 LIKE 'xyz' AND Id IN ('a07B0000000KWZ7IAO', 'e10R0000000KEU9IAO', 'v32B0000000KWZ7YEP') | Generates a notification if f1 or f2 have changed, f3 and f4 match the values in the WHERE clause, and the ID is contained in the WHERE clause IN list. |