+ Start a Discussion
P KP K 

Querying Multi-Select Picklist

I want write down query to fetch value.
where Channel value is equal to Partner(pick list value) and then display value in dependent pick list  Partner Level which have multi pick list values (Diamond , Gold).
how can write down correct query for same.
I have written below like :

String squery = 'SELECT Id, Channel__c,Partner_Level__c from MessageAlert__c AND Partner_Level__c INCLUDES (' + slist + ')';
Ramu_SFDCRamu_SFDC
The below article has some sample queries on multi-select picklists see if this helps

https://developer.salesforce.com/docs/atlas.en-us.soql_sosl.meta/soql_sosl/sforce_api_calls_soql_querying_multiselect_picklists.htm
praveen murugesanpraveen murugesan
Hi,

See this link,

http://salesforce.stackexchange.com/questions/41618/soql-query-to-compare-multiselect-picklist-with-a-variable

Mark this as best answer if its helps.

Thanks.

Praveen Murugesan