You need to sign in to do that
Don't have an account?
mohan naga manikanta karimsetti
SOQL query with Multi Select Picklist in where clause
List<String> newMultiSelectList = new List<String>();
newMultiSelectList.add('Pro-Life'); newMultiSelectList.add('Establishment'); newMultiSelectList.add('GOP');
string value = '('' + String.join(newMultiSelectList, '','')+'')';
// I need results that includes all the three values (AND Condition)
//I tried this, but it is taking as OR condition
String queryString = 'select id, Audience_Tags__c FROM Audience__c WHERE Audience_Tags__c INCLUDES'+value;
List<Audience__c> newlist = DataBase.query(queryString); system.debug('List of records: '+newlist);
Any help would be appreciated
newMultiSelectList.add('Pro-Life'); newMultiSelectList.add('Establishment'); newMultiSelectList.add('GOP');
string value = '('' + String.join(newMultiSelectList, '','')+'')';
// I need results that includes all the three values (AND Condition)
//I tried this, but it is taking as OR condition
String queryString = 'select id, Audience_Tags__c FROM Audience__c WHERE Audience_Tags__c INCLUDES'+value;
List<Audience__c> newlist = DataBase.query(queryString); system.debug('List of records: '+newlist);
Any help would be appreciated
https://help.salesforce.com/articleView?id=000334304&type=1&mode=1
https://developer.salesforce.com/docs/atlas.en-us.soql_sosl.meta/soql_sosl/sforce_api_calls_soql_querying_multiselect_picklists.htm
Thanks,
Now you can use this value in query with Includes operator.
Thanks,
Abhishek Bansal.