Newer Version Available
NotifyForFields Set to All
When you set the value of PushTopic.NotifyForFields to All, a change to any field value in the record causes the Streaming API matching logic to evaluate the record to determine whether to generate a notification. Changes to record field values cause this evaluation whether or not those fields are referenced in the PushTopic query SELECT clause or WHERE clause.
| 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 record field values match the values specified in the WHERE clause. |
Examples
| PushTopic Query | Result |
|---|---|
| SELECT Id, f1, f2, f3 FROM Invoice_Statement__c | Generates a notification if any field values in the record have changed. |
| SELECT Id, f1, f2 FROM Invoice_Statement__c WHERE f3 = 'abc' AND f4 LIKE 'xyz' | Generates a notification if any field values in the record have changed and f3 and f4 match the values in the WHERE clause. |
| SELECT Id FROM Invoice_Statement__c | When Id is the only field in the SELECT clause, a notification is generated if any field values have changed. |
| SELECT Id FROM Invoice_Statement__c WHERE f3 = 'abc' AND f4 LIKE 'xyz' | Generates a notification if any field values in the record have changed and f3 and f4 match the values in the WHERE clause. |
| SELECT Id FROM Invoice_Statement__c WHERE Id IN ('a07B0000000KWZ7IAO', 'e10R0000000KEU9IAO', 'v32B0000000KWZ7YEP') | Generates a notification if any field values in the record have changed and the record ID is contained in the WHERE clause IN list. |
| SELECT Id, f1, f2 FROM Invoice_Statement__c WHERE Id IN ('a07B0000000KWZ7IAO', 'e10R0000000KEU9IAO', 'v32B0000000KWZ7YEP') | Generates a notification if any field values in the record have changed and the record 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 any field values in the record have changed, f3 and f4 match the WHERE clause, and the record ID is contained in the WHERE clause IN list. |