You need to sign in to do that
Don't have an account?
P 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 + ')';
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 + ')';
https://developer.salesforce.com/docs/atlas.en-us.soql_sosl.meta/soql_sosl/sforce_api_calls_soql_querying_multiselect_picklists.htm
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