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
Vikram Singh 157Vikram Singh 157 

Hi All ! i am trying to retrieve the name of positions from custom object by the use of multi select pick list but it is given an error as given below:

Position__c [] c= [Select Name From Position__c Where Status__c INCLUDES ('New Position;Open - Approved')];

The api name already verified .
Error :- 
Select Name From Position__c Where Status__c INCLUDES ('New Position;Open
                                   ^
ERROR at Row:1:Column:36
includes or excludes operator only valid on multipicklist field
Shruti SShruti S
Try this query, it should work -  
Select Name From Position__c Where Status__c IN('New Position','Open - Approved')
Vikram Singh 157Vikram Singh 157
Thanks Shruti , it works.
Shruti SShruti S
So happy to help and glad to know it was solved.

Please mark the question as solved, if it has cleared your query as it might help someone. 

Have a Great Day,
Shruti