You need to sign in to do that
Don't have an account?
Mahesh sfdc 5
Urgent : Can any one tell me how to resolve First error: [QUERY_TIMEOUT] Your query request was running for too long."?
Hi All,
Any on know how to resolve First error: [QUERY_TIMEOUT] Your query request was running for too long." ?
This the query I am using in my batch class start Method:
filterDate is Today date.
query = 'SELECT Id, Case__c FROM Case_Action__c WHERE Case__r.ClosedDate >= ' + filterDate + ' OR Case__r.ClosedDate = NULL ORDER BY Case__r.Temp_Case_Action_Date__c';
If any one help will appriciate.
Thanks,
Mahesh
Any on know how to resolve First error: [QUERY_TIMEOUT] Your query request was running for too long." ?
This the query I am using in my batch class start Method:
filterDate is Today date.
query = 'SELECT Id, Case__c FROM Case_Action__c WHERE Case__r.ClosedDate >= ' + filterDate + ' OR Case__r.ClosedDate = NULL ORDER BY Case__r.Temp_Case_Action_Date__c';
If any one help will appriciate.
Thanks,
Mahesh
Please check below post to improve your query
1) https://developer.salesforce.com/docs/atlas.en-us.apexcode.meta/apexcode/langCon_apex_SOQL_VLSQ.htm
Let us know if this will help you
Can you remove the or condition and check once ,what I feel lot of records returning with closeddate with null value .
Check how many case records are there in your org .Then remove or condition and check ,Let us know if it helps !!
Thanks
Manoj
Batch job is getting only 3000 records for this query.
Thanks,
Mahesh