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 |
