Toggle Side Panel
Close search

Activity › Forums › Salesforce® Discussions › How to debug the child values in parent to child query using for loop?

Tagged: , , , ,

  • Salesforce® Discussions

    How to debug the child values in parent to child query using for loop?

    Posted by Audrey on April 21, 2016 at 6:37 AM

    List<Account> accs=[select id,name,Phone,
    (select id,lastname,firstname,email
    from contacts)
    from account];

    for(Account aa:accs){
    System.debug(aa.id);
    System.debug(aa.name);
    System.debug(aa.phone);
    }
    for(Contact con:accs.contacts){

    }

    The first loop runs error free while the second loop throws up some error. I have the parent values in the first loop but i need the child values in it as well. Can anyone help?

    shariq replied 7 years, 10 months ago 4 Members · 3 Replies
  • 3 Replies

  • Naman

    Member
    April 21, 2016 at 8:14 AM

    What error you are getting in second for loop?

    As multiple contacts could be associated with single account so, to traverse the contact you would need second for loop inside first. Debug contact values in second for loop. you can do like:

    for(Account aa:accs){
    System.debug(aa.id);
    System.debug(aa.name);
    System.debug(aa.phone);

    for(Contact con:accs.contacts){

    System.debug(con.email);

    }
    }

  • [adinserter block='9']

  • Parul

    Member
    September 20, 2018 at 12:20 AM

    Hello,

    Could you let me know the error??

    Thanks

  • shariq

    Member
    September 20, 2018 at 7:52 PM

    Hi,

    Could you tell me your requirements that what you are trying to do.

    thanks.

Log In to reply.

Popular Salesforce Blogs

Popular Salesforce Videos
Salesforce Interview Questions and Answers - For Freshers and Experienced Candidates

Salesforce Interview Questions and Answers - For Freshers and Experienced Candidates

Video in Salesforce Stories, Salesforce Training

Learn most important Salesforce Interview Questions and Answers, asked at every interview. These Interview questions will be useful to all entry-level candidates, beginners, interns, and…

Salesforce Developers, Salesforce Training Video, Salesforce Interview Questions, Interview Questions and Answers, Salesforce Interview Questions and Answers
Neha Yadav Jun 2, 2020
1,942  Views
Skip to toolbar