You need to sign in to do that
Don't have an account?
jwolf
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?
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?