[SalesForce] How To Retrieve the Related List Data

I have a Object called SiteContracts__c and it has a Related List Object is Engineer_CheckList__c", now I want to get the Engineer_CheckList__c record which is related to SiteContracts__c how can I retrieve those records using SOQL ?

For the records in Engineer_CheckList__c object we have Lookup to select the SiteContracts__c.

Update:

I am getting the following Error while using this Query through Developer Console

Id, Name, (Select Id, Name From Engineer_Checklist__r) From
SiteContracts__c ^ ERROR at Row:1:Column:40 Didn't understand
relationship 'Engineer_Checklist__r' in FROM part of query call. If
you are attempting to use a custom relationship, be sure to append the
'__r' after the custom relationship name. Please reference your WSDL
or the describe call for the appropriate names.

Best Answer

Karti, probably Didn't understand relationship 'Engineer_Checklist__r says that relationship name is different than 'Engineer_Checklist__r'.

Ensure that relation name is correct, you can use https://workbench.developerforce.com tooll

Go to: Info -> standard & custom obj (choose your object) -> Child relationship -> relationshipName

Related Topic