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, Lead, Opportunity, Task. The following standard objects are supported in PushTopic queries through a pilot program: ContractLineItem, Entitlement, LiveChatTranscript, Quote, QuoteLineItem, ServiceContract.

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
Standard objects (may include custom fields)
- Account
- Campaign
- Case
- Contact
- Lead
- Opportunity
- Task
  - 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

Force.com Streaming API Developer's Guide

Supported PushTopic Queries