Sign Up ›

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
SHRAVAN K 6SHRAVAN K 6 

SOQL Query Error- Batch Job

 return Database.getQueryLocator([select userorGroupid from groupmember where group.name='GroupnameXYZ' and userorgroupid in (Select id,contact.AP_Status__c from user where contact.Fieldxyz__c!='Available' and isactive=True)]);

Compile Error: unexpected token: , 
 
Best Answer chosen by SHRAVAN K 6
Chris SalgadoChris Salgado
In the nested query try taking out the 2nd field (contact.AP_Status__c) so it returns just a list of ID's

All Answers

Chris SalgadoChris Salgado
In the nested query try taking out the 2nd field (contact.AP_Status__c) so it returns just a list of ID's
This was selected as the best answer
SHRAVAN K 6SHRAVAN K 6
Can you share any documentation related to this?