SQL-Sales supports querying a number of Tooling api objects which mandate a particular way of querying (the “a filter on a reified column is required”) Salesforce constraints as these objects are essentially virtual.
Object Name | Field Name | Where Clause / Notes |
PicklistValueInfo | DurableId | WHERE DurableId = ''Account.Industry.Consulting'' |
PicklistValueInfo | EntityParticleId | WHERE EntityParticleId = ''Account.Industry'' |
FieldDefinition | DurableId | WHERE DurableId = ''Account.Name'' |
FieldDefinition | EntityDefinitionId | WHERE EntityDefinitionId = ''Account'' |
FieldDefinition | EntityDefinitionId | WHERE EntityDefinitionId in (''Account'',''Contact'') |
FieldDefinition | remote example | WHERE EntityDefinition.QualifiedApiName = ''Account'' |
RelationshipDomain | DurableId | not queryable |
RelationshipDomain | ChildSobjectId | WHERE ChildSobjectId = ''Account'' |
RelationshipDomain | FieldId | WHERE FieldId = ''Account.Parent'' |
RelationshipDomain | ParentSobjectId | WHERE ParentSobjectId = ''Account'' |
RelationshipDomain | RelationshipInfoId | not queryable |
RelationshipInfo | ChildSobjectId | WHERE ChildSobjectId = ''Account'' |
RelationshipInfo | FieldId | WHERE FieldId = ''Account.Owner'' |
RelationshipInfo | DurableId | not queryable |
EntityParticle | FieldDefinitionId | WHERE FieldDefinitionId = ''Account.AccountSource'' |
EntityParticle | EntityDefinitionId | WHERE EntityDefinitionId = ''Account'' |
EntityParticle | DurableId | WHERE DurableId = ''Account.AccountSource'' |
RelatedListDefinition | ParentEntityDefinitionId | WHERE ParentEntityDefinitionId = ''Account'' |
RelatedListDefinition | DurableId | WHERE DurableId = ''Account.RelatedActivityList'' |
RelatedListDefinition | remote example | WHERE ParentEntityDefinition.QualifiedApiName = ''Account'' |
RelatedListColumnDefinition | RelatedListDefinitionId | WHERE RelatedListDefinitionId = ''Account.RelatedActivityList'' |
RelatedListColumnDefinition | DurableId | WHERE DurableId = ''Account.RelatedActivityList.OWNER_ROLE'' |
Publisher | NamespacePrefix | WHERE NamespacePrefix = ''SQLSales'' |
|
|
|
PackageLicense.NamespacePrefix |
|
|
Publisher | DurableId | WHERE DurableId = ''SQLSales'' |
UserEntityAccess | UserId | WHERE UserId = ''005QH0000013r5dYAA'' |
|
|
|
User.Id |
|
|
UserEntityAccess | DurableId | WHERE DurableId = ''ProcessInstance.005QH0000013r5dYAA'' |
UserFieldAccess | DurableId | WHERE DurableId = ''Account.Name.005QH0000013r5dYAA'' |
|
|
|
User.Id |
|
|
TabDefinition | DurableId | WHERE DurableId = ''Account'' |
SiteDetail | DurableId |
|
SearchLayout | DurableId | WHERE DurableId = ''Account.SearchResult'' |
SearchLayout | EntityDefinitionId | WHERE EntityDefinitionId = ''Account'' |
ColorDefinition | DurableId | WHERE DurableId = ''Account-theme3'' |
ColorDefinition | TabDefinitionId | WHERE TabDefinitionId = ''Account'' |
OwnerChangeOptionInfo | DurableId | WHERE DurableId = ''Account.SendEmail'' |
OwnerChangeOptionInfo | EntityDefinitionId | WHERE EntityDefinitionId = ''Account'' |
FlowVersionView | FlowDefinitionViewId | WHERE FlowDefinitionViewId = ''industries_fsc__CreateSlackAccChannel'' |
|
|
|
exec ss_Replica 'xxx', 'FlowDefinitionView','subset(DurableId)','WHERE DurableId like ''%a%''' |
|
|
pass FlowDefinitionView.DurableId as the FlowDefinitionViewId |
|
|
FlowVersionView | DurableId | WHERE DurableId = ''industries_fsc__CreateSlackAccChannel-1'' |
FlowVariableView | FlowVersionViewId | WHERE FlowVersionViewId = ''industries_fsc__CreateSlackAccChannel-1'' |
|
|
|
FlowVersionView.DurableId = FlowVariableView.FlowVersionViewId |
|
|
FlowVariableView | DurableId | WHERE DurableId = ''industries_fsc__CreateSlackAccChannel-1.recordId'' |
IconDefinition | TabDefinitionId | WHERE TabDefinitionId = ''Account'' |
IconDefinition | DurableId | WHERE DurableId = ''Account-theme3-16'' |
ApexTypeImplementor | InterfaceName |
|
ApexTypeImplementor | DurableId |
|
AppTabMember | TabDefinitionId |
|
AppTabMember | AppDefinitionId | WHERE AppDefinitionId = ''06mQH000000iazzYAA'' |
|
|
|
AppTabMember.AppDefinitionId = AppDefinition.Id |
|
|
AppTabMember | DurableId | WHERE DurableId = ''06mQH000000iazzYAA-Account'' |
FlowTestView | FlowDefinitionViewId | WHERE FlowDefinitionViewId = ''industries_fsc__CreateSlackAccChannel'' |
|
|
|
exec ss_Replica 'xxx', 'FlowDefinitionView','subset(DurableId)','WHERE DurableId like ''%a%''' |
|
|
pass FlowDefinitionView.DurableId as the FlowDefinitionViewId |
|
|
FlowTestView | DurableId |
|