I am executing the following query:

FIND {LANDWAGEN} IN ALL Fields RETURNING Product2(ProductCode ORDER BY ProductCode)

I know there are products with this value in the Family field, but 0 rows are returned. Why is that?


Picklist fields are not search indexed. Use SOQL instead. See Searchable Fields by Object in Lightning Experience and Searchable Fields by Object in Salesforce Classic.

  • I must use SOSL, because I want the search term (entered by users) to search in all product fields. I guess I have to create a custom field. – Sander de Jong Sep 16 '20 at 6:18

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.