function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ 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