Hello,

I have two custom objects job and Campaign with Lookup relationship. (Campaign is Master and Job is Child)

i want to display list of Campaign with its child records in a visualforce page , and i am using this code -:

public with sharing class JobTest1

{

    // Global variables

     public String JName {get; set;}

   

     // Start Constructor

     public JobTest1()

     {

         today=System.Today();

     }

     // End of Constructor

 

    public class cNodes

    {

         public List<Job__c> parent {get; set;}

         Public Campaign__c gparent {get;set;}

         public cNodes(Campaign__c  gp, List<Job__c> p)

         {

             parent = p;

             gparent = gp;

         }

    }

 

    Public List<cNodes> hierarchy;

 

    Public List<cNodes> getmainnodes()

    {

        hierarchy = new List<cNodes>();

        List<Campaign__c> tempparent = [Select Id,Name from Campaign__c LIMIT 10000];

        for (Integer i =0; i< tempparent.size() ; i++)

        {

               List<Job__c> tempchildren = [Select Id,Name,Job_Id__c,Client__c,Client__r.Name,Campaign__c,Completion_Date__c,Start_Date__c,Due_Date__c from Job__c where Campaign__c = :tempparent[i].Id Order By Name];

               hierarchy.add(new cNodes(tempparent[i],tempchildren));

        }  

        return hierarchy;

    }  

}

 It works if there is less record,but if records are huge it throws following error -:

 System.LimitException: JobSuite:Too many SOQL queries: 101

How can we fix this issue.

Thanks