Sign Up ›

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
mobile vistexmobile vistex 

how to get field of child object

Hi 
iam query a data like follwing 
list<Header__c> obj = [ Select Employee__c,
                   Employee_First_Name__c,
                   Employee_Last_Name__c,
                    Total_YTD_Achievement__c,
                    Manager_ID__c,
                    Manager_ID_Descr__c,
                    Trend__c,
            ( Select Tracking_Number__c,
                            Department_Code__c,
                            Plan_Definition__c,
                            SIP_Amount__c,
                            SIP_Split__c,
                            Cal_YTD_SIP_Amount__c,
                            Actual_Amount__c,
                            Target_Amount__c,
                            Result__c,
                            Payment__c,
                           Cal_YTD_Achievement__c
                            from TrackingItem__r    )
                      from Header__c order by Quarter__c
                   //   where Employee_ID__c = :user 
                     ];

for(header__C k : obj){
da.add(k.Employee__c);
da.add(k.Employee_First_Name__c);
da.add(k.Employee_Last_Name__c);
da.add(k.Manager_ID__c);
da.add(k.Manager_ID_Descr__c);
da.add(k.Department_Code__c);}

when  iam adding the related child field it is giving error field not found.,..
how can i add  the related field to that list
Best Answer chosen by mobile vistex
Himanshu ParasharHimanshu Parashar
Hi,

You can't access Department_code__c in that way because this is child of your parent record. SFDC return child records in list so you need to iterate over that list in following way.
  
for(header__C k : obj){ 
da.add(k.Employee__c); 
da.add(k.Employee_First_Name__c); 
da.add(k.Employee_Last_Name__c); 
da.add(k.Manager_ID__c);
da.add(k.Manager_ID_Descr__c); 
//da.add(k.Department_Code__c);

for(TrackingItem__c tr : k.TrackingItem__r) {
 system.debug('*************'+ tr.Department_Code__c);
);
}

}

Thanks,
Himanshu