[SalesForce] Using In Clause with multi pick list

I'm trying to query some data in access from a multi pick-list using this query:

SELECT Contact.Account.Name, Contact.LastName, Contact.FirstName, Contact.Email, Contact.Title, Contact.Summit_History__c
FROM Contact
WHERE Contact.Summit_History__c in ('OOTS-2014-US-Speaker')

The problem is that it's only returning rows where the Summit_History is just "OOTS-2014-US-Speaker". Is there a way to do a fuzzy search, so that I'm returning rows that have this as at least one of the options, but not exclusively that option?

Best Answer

You need to use the INCLUDES

SELECT Contact.Account.Name, Contact.LastName, Contact.FirstName, Contact.Email, Contact.Title, Contact.Summit_History__c
FROM Contact
WHERE Contact.Summit_History__c INCLUDES ('OOTS-2014-US-Speaker','myValue2','myValue3')

This will return any results that have at least one of the values in the INCLUDES filter. if you need to filter for specific combinations, you'll ned to use this format

SELECT Contact.Account.Name, Contact.LastName, Contact.FirstName, Contact.Email, Contact.Title, Contact.Summit_History__c
FROM Contact
WHERE Contact.Summit_History__c INCLUDES ('OOTS-2014-US-Speaker','myValue2; myValue3')

This will yield any results that contain 'OOTS-2014-US-Speaker' OR ('myValue2' AND 'myValue3')

Related Solutions

[SalesForce] Query single pick list with values from multi select pick list

Multi-select picklists look like a semi-colon delimited string to your code. So, you can just use split(';') to get an array of all the picklist values. You can then use the IN operator.

SELECT Name from Object__c where PicklistField__c IN :multselect.split(';')

[SalesForce] Querying against a multi-select picklist

If you are querying against a mulit-select picklist, you need to use includes in your query.

list subscriptionCampaigns = [
    SELECT ID FROM Campaign 
    WHERE Newsetter_Subscriptions__c INCLUDES :contactSubscriptions];

If Newsletter_Subscriptions__c is the multi-select and contactSubscriptions contains all of the values you want this should return any Campaign that has at least one selected. If you need to only select those that match all then you need to join the contactSubscriptions into a single semi-colon delimited string and have that as the only item on the list

There are some more examples in the Querying Multi-Select Picklist docs

Best Answer

Related Solutions

[SalesForce] Query single pick list with values from multi select pick list

[SalesForce] Querying against a multi-select picklist

Related Topic