function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
eliotstock2eliotstock2 

referring to children in a parent-to-child subquery

Hi.

 

I have a parent to child subquery like this:

 

for (Parent__c parent : [
   SELECT Parent_Field__c, (SELECT Id, Child_Field__c FROM Childs__r WHERE Id IN :childIds)
   FROM Parent__c]) {
   // Do something with parent.Parent_Field__c
}
 
If I have one parent with two children, I expect this to get me two records back. My question is, how do I then refer to the children of the parent? None of these seem to work:
 
 
parent.Childs__r.Child_Field__c
parent.Childs__c.Child_Field__c
parent.Child__r.Child_Field__c
parent.Child__c.Child_Field__c
 
 
Thanks,
 
Eliot Stock. 


Best Answer chosen by Admin (Salesforce Developers) 
wesnoltewesnolte
Hey
 
Yeah it's a little different from child to parent. In your case you have to use a sort of Array syntax:
 
parent.childs__r[0].child_field__c
 
would access the first child.
 
Cheers,
Wes