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개
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
