Hello community !
I'm trying to use the Filter Query of the Salesforce Get Records connector on a Multiselect picklist field.
Say the field is Color__c and the different choices are blue, red, white, yellow, I would like to return all records which contain "blue"
So far I do Color__c eq 'Blue' but it returns something that only strictly contains 'blue', and not 'blue','yellow' etc...
I have tried other method described in ODATA, like substring(), includes, none of them work but maybe I did not use it correctly.
If there is also a workaround without using the ODATA query I would be curious
Thanks a lot for your help !
Edit - Sorry if I did not put this in the right category, feel free to move it ! I'm new here.
You can find the Filter Query documentation directly on the Salesforce connector documentation:
I would also recommend you to take a look at the Known Issues and Limitation for the connector: