You need to sign in to do that
Don't have an account?
SOQL on all custom objects
Hi,
public class CustomObjectsInPickListCntrl
{
public String val {get;set;}
public void getName()
{
List<SCHEMA.SOBJECTTYPE> gd = Schema.getGlobalDescribe().Values();
List<String> customObjectList = new List<String>();
for(Schema.SObjectType f : gd)
{
Schema.DescribeSObjectResult res = f.getDescribe();
if(res.isCustom())
{
if(!res.isCustomSetting())
{
customObjectList.add(f.getDescribe().getName());
}
}
}
}
}
In the above code customObjectList has all custom objects
I have to get like this
for(SObject s : customObjectList){
List<s> slist = [Select Id LastModifiedDate from s];
}
If I wirte like this I will get SOQL Exception (100), so How I can do now. Please advice any one.
public class CustomObjectsInPickListCntrl
{
public String val {get;set;}
public void getName()
{
List<SCHEMA.SOBJECTTYPE> gd = Schema.getGlobalDescribe().Values();
List<String> customObjectList = new List<String>();
for(Schema.SObjectType f : gd)
{
Schema.DescribeSObjectResult res = f.getDescribe();
if(res.isCustom())
{
if(!res.isCustomSetting())
{
customObjectList.add(f.getDescribe().getName());
}
}
}
}
}
In the above code customObjectList has all custom objects
I have to get like this
for(SObject s : customObjectList){
List<s> slist = [Select Id LastModifiedDate from s];
}
If I wirte like this I will get SOQL Exception (100), so How I can do now. Please advice any one.
http://www.salesforce.com/us/developer/docs/apexcode/Content/apex_batch_interface.htm
Please move query out of "for loop". Refer section "Using Collections, Streamlining Queries, and Efficient For Loops" in following help document:
http://wiki.developerforce.com/page/Apex_Code_Best_Practices
Thanks for reply, Can you please send sample code on batch apex to query single latest record(based on LastModifiedDate) from each object without getting SOQL exception?
Note: I have to query on all custom objects in my sandbox(~500).