You need to sign in to do that
Don't have an account?
Sandy Gali
SOQL Query - Workbench - Error
Hi All,
I need to run queries as part of my work which sometimes includes more than say 800 values in 'IN' condition. When I run this query i get an error saying " Unknown Asynchronous State"
I eventually end up doing it in Dataloader where the same query works fine.
Were any of you succesful in resolving this issue.
My query looks something like this
SELECT name,age FROM Applicant__c where name in ('A1',
'A2',
.
.
.
.
'A850')
I need to run queries as part of my work which sometimes includes more than say 800 values in 'IN' condition. When I run this query i get an error saying " Unknown Asynchronous State"
I eventually end up doing it in Dataloader where the same query works fine.
Were any of you succesful in resolving this issue.
My query looks something like this
SELECT name,age FROM Applicant__c where name in ('A1',
'A2',
.
.
.
.
'A850')
First add all your name values to a SET or List then use IN operator. Below is sample code.
Best Regards,
Mithun.
"Long, complex SOQL statements, such as statements that contain many formula fields, can sometimes result in a QUERY_TOO_COMPLICATED error. The error occurs because the statement is expanded internally when processed by Salesforce, even though the original SOQL statement is under the 20,000 character limit. To avoid this, reduce the complexity of your SOQL statement."