In SOQL, you can traverse up to a maximum of five levels when querying data from child object to parent.

SELECT Name, Position__r.Contact.Account.Owner.FirstName 

FROM Job_Application__c;

SELECT Name, (SELECT Name FROM Job_Applications__r)

FROM Position__c

Five Levels:

Job Application → Position → Contact → Account → User

Our Recent Blog

Share This Post