LinkedEntity polymorphic relationship field not returning data on SOQL
We have a custom object Client_Intake_Upload__c with custom field Hub_Spoke_Account__c that is connected to ContentDocumentLink object. The polymorphic relationship field on ContentDocumentLink is called LinkedEntity. When we run the query below, ContentDocumentId and LinkedEntityId get returned but not Hub_Spoke_Account__c (which is not null).
SELECT ContentDocumentId, LinkedEntityId , TYPEOF LinkedEntity WHEN Client_Intake_Upload__c THEN Hub_Spoke_Account__c END FROM ContentDocumentLink WHERE LinkedEntityId IN (SELECT Id FROM Client_Intake_Upload__c Where Status__c="Uploaded")
How can we get Hub_Spoke_Account__c to show?
Read more here: Source link