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
VinOKVinOK 

INVALID_QUERY_FILTER_OPERATOR: invalid operator on multipicklist field

I'm trying to query the sforce api with the following querystring:

"select firstName, lastName, myMultiField from Contact where myMultiField != null "

I keep getting the error INVALID_QUERY_FILTER_OPERATOR: invalid operator on multipicklist field. 

What are valid operators for a filter that's based on a multipicklist?

Best Answer chosen by Admin (Salesforce Developers) 
sabamonasabamona

Please use the following query instead:

 

"select firstName, lastName, myMultiField from Contact where myMultiField != '' "

 

This would work  :)

All Answers

benjasikbenjasik
Can you try includes('')

I believe this is a new keyword for multiselect picklists. excludes will also work.
sabamonasabamona

Please use the following query instead:

 

"select firstName, lastName, myMultiField from Contact where myMultiField != '' "

 

This would work  :)

This was selected as the best answer