-
Is there any way to define more than 1 SOQL quires in a batchable class start method in Salesforce?
I have run into a case where i have to do same operation via batch over records in same object. But i cannot construct a query which can retrieve all of those records. Is there is way to achieve it with a single batchable class or i would have to create multiple classes.
-
1 Reply
-
Hi Deepak,
if you are want to query the same object type but with multiple different WHERE selection clauses, and you then want to just apply the same logic to them, this is a simple matter of appropriately parenthesizing and combining the clauses into a single WHERE.
For example, if your first query is looking for instances matching:
A__c = ‘123’ AND B__c = ‘xyz’
while your second query is looking for instance matching:
A__c = ‘987’ AND (B__c = ‘abc’ OR C__c = 999)
then you can construct your query as:SELECT Id, … FROM MyObject__c WHERE
(A__c = ‘123’ AND B__c = ‘xyz’) OR
(A__c = ‘987’ AND (B__c = ‘abc’ OR C__c = 999))
Log In to reply.
