0

Reading about 'includes' filter on SOSL I have a question:

What happens if I do: ...MyCustomField__c includes ('valueA,valueB') ?

What i know:.
If I do: ...MyCustomField__c includes ('valueA;valueB') it will return results with valueA OR valueB.
If I do: ...MyCustomField__c includes ('valueA','valueB') it will return results with valueA AND valueB

Moreover for: ...MyCustomField__c includes ('valueA,valueB') is not clear for me what happens...

Any ideas? Thanks!

Documentation: https://developer.salesforce.com/docs/atlas.en-us.soql_sosl.meta/soql_sosl/sforce_api_calls_soql_querying_multiselect_picklists.htm#topic-title

6
  • The doc you're referencing is for searching the multi-select picklist field values. Is your field a multi-select picklist?
    – identigral
    Feb 15, 2023 at 1:43
  • Yes, it's a multi-select picklist Feb 15, 2023 at 8:29
  • And have you actually tried that on any example? What were the results? Feb 15, 2023 at 9:19
  • Sorry, but why are you not trying? Feb 15, 2023 at 9:32
  • Yes I did but I have random results. I could not find the pattern, that's why I am asking. Feb 15, 2023 at 9:38

0

You must log in to answer this question.

Browse other questions tagged .