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.