[SalesForce] SOSL Multiple Search Words

Trying to search multiple terms in SOSL in APEX. I tried this singular, of course works:

[FIND 'searchOne' IN ALL FIELDS RETURNING ACCOUNT]

But these don't work:

[FIND 'searchOne' OR 'searchTwo' ....
[FIND {'searchOne','searchTwo'} ....
[FIND (searchOne', 'searchTwo') ....

Error is:

'(' not expected (or something..etc)

My goal is bulkification and searching a value in an Encrypted Field. I want to be able to get all matching records based on a set of terms.

Best Answer

In Apex, it's just a normal string:

[FIND 'searchOne or searchTwo' in all fields ...

This syntax is slightly different than the API, which is probably where the confusion is coming from. You can also use quotation marks (") to group terms, etc, just like you can in normal SOSL.

[FIND '"searchOne" or "searchTwo"' in all fields ...

Related Solutions

[SalesForce] SOSL query field limitations

It would appear the picklist fields are not searchable with SOSL.

You can confirm this by checking the DescribeFieldResult for the field in question.

Schema.DescribeFieldResult dfr = Schema.SObjectType.Case.fields.Product__c;
System.debug(dfr.isSearchPrefilterable());

What isn't 100% clear is why a field that isn't "prefilterable" in the SOSL where clause would also be excluded from any SOSL indexes.

There is also the associated Idea : Include pick list values in search, which confirms other users finding that picklists are excluded from SOSL results.

[SalesForce] SOSL query searching in multiple fields

You can't specify individual fields this way. The only options for IN X FIELDS are:

ALL FIELDS
NAME FIELDS
EMAIL FIELDS
PHONE FIELDS
SIDEBAR FIELDS

If you'd like, you can provide filters on the individual objects, such as:

FIND :term IN ALL FIELDS
RETURNING Lead(Name, Company WHERE Name LIKE :filter OR Company LIKE :filter)...

Best Answer

Related Solutions

[SalesForce] SOSL query field limitations

[SalesForce] SOSL query searching in multiple fields

Related Topic