Skip to main content
Topics#Customer ServiceMohan potru's Question
Mohan potru asked in #Customer Service
Oct 31, 2013, 7:12 AM

list creation

for(Activity_Master__c a : [Select id,Code__c,Name,Description__c,Frequency__c,Functional__c,Priority__c,Time_Zone__r.name FROM Activity_Master__c

 

                            where Status__c = 'Active' and id in (Select Activity_Name__c from CT_Org_Activity_Mapping__c

 

                                                                     WHERE Organisation_Level_Name__c = :orgid) limit:limitval offset:offsetval])

 

                 {

 

                    actList.add(new activitywrapper(a));

 

                 }

 

i want to create list for this SOQL query ..how anybody help me
2 answers
  1. Shivanath Devinarayanan (Asymbl Inc)
    Oct 31, 2013, 8:00 AM
    I'm not sure if i quite got your requirement

     

    The list for the out put of that nested SOQL would be 

     

    List<Activity_Master__c> act = [Select id,Code__c,Name,Description__c,Frequency__c,Functional__c,Priority__c,Time_Zone__r.name FROM Activity_Master__c

     

                                where Status__c = 'Active' and id in (Select Activity_Name__c from CT_Org_Activity_Mapping__c

     

                                                                         WHERE Organisation_Level_Name__c = :orgid) limit:limitval offset:offsetval];

     

    Let me know if i could help you better 
Write an answer...
0/9000