Newer Version Available
Supported PushTopic Queries
All custom objects are supported in PushTopic queries. A subset of standard objects is
supported in PushTopic queries, including:
- Account
- Campaign
- Case
- Contact
- ContractLineItem
- Entitlement
- Lead
- LiveChatTranscript
- MessagingSession
- Opportunity
- Quote
- QuoteLineItem
- ServiceAppointment
- ServiceContract
- Task
- UserServicePresence
- WorkOrder
- WorkOrderLineItem
Not all objects may be available in your org. Some objects require specific feature settings and permissions to be enabled.
Also, the standard SOQL operators as well as most SOQL statements and expressions are supported. Some SOQL statements aren’t supported. See Unsupported PushTopic Queries.
The following are examples of supported SOQL statements.
- Custom
object
1SELECT Id, MyCustomField__c FROM MyCustomObject__c - Standard objects (can include custom fields)
- Account
1SELECT Id, Name FROM Account WHERE NumberOfEmployees > 1000 - Campaign
1SELECT Id, Name FROM Campaign WHERE Status = 'Planned' - Case
1SELECT Id, Subject FROM Case WHERE Status = 'Working' AND IsEscalated = TRUE - Contact
1SELECT Id, Name, Email FROM Contact; - Lead
1SELECT Id, Company FROM Lead WHERE Industry = 'Computer Services' - Opportunity
1SELECT Id, Name, Amount FROM Opportunity WHERE CloseDate < 2011-06-14 - Task
1SELECT Id, Subject, IsClosed, Status FROM Task WHERE isClosed = TRUE
- Account