Tooling API
jNewer Version Available
SOQL Operation Limitations
Some Tooling API objects have
SOQL limitations.
The following objects in Tooling API don’t support SOQL operations COUNT(), GROUP BY, LIMIT, LIMIT OFFSET,
OR, and NOT.
- CompactLayoutInfo
- CompactLayoutItemInfo
- DataType
- EntityDefinition
- EntityLimit
- EntityParticle
- FieldDefinition
- Publisher
- RelationshipDomain
- RelationshipInfo
- SearchLayout
- ServiceFieldDataType
- StandardAction
- TimeSheetTemplate
- UserEntityAccess
- UserFieldAccess
The unsupported operations for these objects return errors or incorrect results as these examples illustrate.
- GROUP BY
- Example Query: SELECT COUNT(qualifiedapiname), isfeedenabled FROM EntityDefinition GROUP BY isfeedenabled
- Error Returned: The requested operation is not yet supported by this SObject storage type, contact salesforce.com support for more information.
- LIMIT, LIMIT OFFSET
- Example Queries:
- SELECT qualifiedapiname FROM EntityDefinition LIMIT 5
- SELECT qualifiedapiname FROM EntityDefinition LIMIT 5 OFFSET 10
- An incorrect result is returned because LIMIT and LIMIT OFFSET are ignored.
- NOT
- Example Query: SELECT qualifiedapiname FROM EntityDefinition WHERE qualifiedapiname!='Account'
- Error Returned: Only equals comparisons permitted
- OR
- Example Query: SELECT qualifiedapiname, keyprefix FROM EntityDefinition WHERE isdeletable=true OR (isfeedenabled=false AND keyprefix='01j')
- Error Returned: Disjunctions not supported
MetadataComponentDependency (Pilot) doesn’t support GROUP BY or aggregate functions other than COUNT().