I am developing a search function for a community that has to implmenent a SOSL Query against multiple objects in order to return the accurate results. The issue I've run into is that when querying against a Text Area (255) field, and Long Text areas, when I search for a string it only works if the entire string is used.
This search will succceed and return the expected results
FIND 'Horse' IN ALL FIELDS RETURNING ccrz__E_ProductSpec__c(Id, Name, ccrz__SpecValue__c) WITH SPELL_CORRECTION = false
This SOSL query fails and returns no results
'FIND 'Hors*' IN ALL FIELDS RETURNING ccrz__E_ProductSpec__c(Id, Name, ccrz__SpecValue__c) WITH SPELL_CORRECTION = false'
The field values are long strings that sometimes contain just 'HORSE', but also could be a longer string. I've tried the * wildcard, as well as the ?, but neither of them works and no results are returned. Is there something I'm missing in the configuration, or is SOSL not going to work in the instance of searching text fields for values.