SOQL for Winter 20 Where is this used functionality

Question

Hi I would like to know how I can query the "Where is this used" relationship via SOQL. Generally, Metadata information on Fields can be found in FieldDefinition and Entity Particle tables, but can the new functionality be queried yet? If not, can I get the info by code, I think Apex DescribeFieldResult does not have apropriate methods...

Answer 1

Yes, after winter20 release we can query metadata decencies using tooling API. So while running this query, "Use Tooling API" checkbox must be checked in developer console.

SELECT MetadataComponentName, MetadataComponentType
FROM MetadataComponentDependency
WHERE RefMetadataComponentType = 'ApexClass'
AND MetadataComponentId = '00NXXXXXXXXXXXXXXX'

Answer 2

Here's some documentation for you: https://developer.salesforce.com/docs/atlas.en-us.api_tooling.meta/api_tooling/tooling_api_objects_metadatacomponentdependency.htm

As someone already mentioned, you can query it using Tooling API.

Answer 3

You cannot do the "Where is this used" query against the MetadataComponentDependency object for out-of-the-box fields like Account.Name at this time. You can do it for custom fields.

You can do these queries through the Developer Console's Query Editor if you check the "Use Tooling API" checkbox. You can also use the REST API, for example, through the Workbench REST Explorer.

STEPS:

1. Get your SObject Id. For out-of-the-box SObjects like Account, the Id is just the SObject name, e.g. "Account". You can find custom SObject Ids with this tooling query: SELECT Id, DeveloperName FROM CustomObject. The corresponding REST API path is: /services/data/v48.0/tooling/query?q=SELECT+Id,DeveloperName+FROM+CustomObject

2. Use that Id to get your SObject's fields: SELECT Id, DeveloperName FROM CustomField WHERE TableEnumOrId = 'Account'. The corresponding REST API path is: /services/data/v48.0/tooling/query?q=SELECT+Id,+DeveloperName+FROM+CustomField+WHERE+TableEnumOrId+=+'Account'

3. Finally, use one or more of those fields' Id values to view usage. Here is a sample query for CustomField with the made-up Id value of 00N123456789012AAA: SELECT Id, MetadataComponentId, MetadataComponentNamespace, MetadataComponentName, MetadataComponentType, RefMetadataComponentId, RefMetadataComponentNamespace, RefMetadataComponentName, RefMetadataComponentType FROM MetadataComponentDependency WHERE RefMetadataComponentId IN ('00N123456789012AAA'). The corresponding REST API path is: /services/data/v48.0/tooling/query?q=SELECT+Id,+MetadataComponentId,+MetadataComponentNamespace,+MetadataComponentName,+MetadataComponentType,+RefMetadataComponentId,+RefMetadataComponentNamespace,+RefMetadataComponentName,+RefMetadataComponentType+FROM+MetadataComponentDependency+WHERE+RefMetadataComponentId+IN+('00N123456789012AAA')

Part of the reason I have provided those REST API paths is because the Developer Console Query Editor never returns more than one row for me for that final query. (It will say it has many "Total Rows", but then it displays only one.)