Skip to main content The Trailblazer Community will be unavailable from 2/1/2025 to 2/2/2025. Please plan your activities accordingly.
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?
1 answer
  1. Jul 3, 2018, 4:12 PM

    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

     
0/9000