Supported PushTopic Queries

All custom objects are supported in PushTopic queries. The following subset of standard objects are supported in PushTopic queries.

Account
Campaign
Case
Contact
ContractLineItem
Entitlement
Lead
LiveChatTranscript
Opportunity
Quote
QuoteLineItem
ServiceContract
Task

Tasks that are created or updated using the following methods don’t appear in task object topics in the streaming API.

Lead conversion
Entity merge
Mass email contacts/leads

Important

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 (may 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
- To receive notifications on the IsClosed field, the subscriber must subscribe to the Status field referenced in the query.
- To receive notifications on the WhoCount and WhatCount fields, the subscriber must subscribe to the WhoId and WhatId fields. Subscriptions based only on the WhoCount or WhatCount fields aren’t supported.
Important

Streaming API Developer Guide

Supported PushTopic Queries