In SOQL ,I do not understand the return value when selecting a field of type Metadata Relationship(Field Definition).
In my custom metaData type
- "controllingObject__c" is of dataType ,Metadata Relationship(Entity Definition)
- "controllingField__c" is of dataType, Metadata Relationship(Field Definition)
Right now I have one record of this type where
- controllingObject__c =Account
- controllingField__c = Account.tier__c (which is a text field)
Here is my SOQL query:
SELECT controllingObject__c, controllingField__c FROM My_Custom_MetaDataType__mdt
controllingObject__c returns "Account" but controllingField__c returns "Account.00N3600000RSyBA".
What is this value? It looks like some type of ID but I didn't think fields had any kind of unique Identifier other than their API Name. Is there a way I can get the API Name of the field from this value?