+ Start a Discussion
Support 3743Support 3743 

Error message: Invalid operator on multipicklist field

This is what I want to do: 
SELECT Account.Name FROM Account WHERE Business_Type__c like '%Manufacturer/Supplier%'

However I'm getting this error: invalid operator on multipicklist field. Could you tell me what it means and how to fix it?
Best Answer chosen by Support 3743
PawanKumarPawanKumar

Please try below.

SELECT Account.Name FROM Account WHERE Business_Type__c INCLUDES ('Manufacturer/Supplier')

Like works only for text field not for multi-select.

Also, refer below for more combinations of search on multi select.
https://developer.salesforce.com/docs/atlas.en-us.soql_sosl.meta/soql_sosl/sforce_api_calls_soql_querying_multiselect_picklists.htm

Please mark best if it works for you. Thanks.

Regards,
Pawan Kumar