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 |
