function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
jwolfjwolf 

What is the search algorithm used by SOSL to search a text field?

I'm having trouble figuring out the expected behavior of my SOSL queries. Could someone give an example or point me to where I could find a more exact specification for SOSL queries other than the page at http://www.salesforce.com/us/developer/docs/api/Content/sforce_api_calls_sosl_find.htm.

Here is an example what I mean:

This is the record I am trying to retrieve:

Solution{SolutionNote=You will need to check either View All Data or Manage Public Reports to allow more visibility., IsPublishedInPublicKb=true, SolutionName=Reports}

This query returns the record as expected

[FIND '*public*' IN ALL FIELDS RETURNING Solution (SolutionNote, SolutionName)]

however the search term '*either*' returns nothing

but the term 'either' returns the record

So, basically in what cases is the '*' match 0 or more characters, and when does it match at least 1?