Hello all,

I'm having issues learning how to properly use the Where clause in COQL.  If I have a query like this..

2. clientSearchMap = Map();
3. clientSearchMap.put("select_query","select id from Contacts where Account_Name = '" + accountId + "' and Relationship_to_Household = 'Client' and Contact_Preference is not 'Do Not Contact' and (Mobile is not null || Email is not null)  ");

Written out a little easier to read..
select id from Contacts where 
- Account_Name = '" + accountId + "'

- Relationship_to_Household = 'Client'

- Contact_Preference is not 'Do Not Contact'

- and (Mobile is not null || Email is not null)

Just in case it makes a difference with the operators, Relationship_to_Household and Contact_Preference are picklists.

I'm sure it's user error on my end, but just wondering what the proper way to setup the criteria would be.

Thanks!

Appending the solution to the requirement to retain context, as the original comment seems to have been removed by the comment owner.