Apex Code Development You need to sign in to do that
Don't have an account?
Leonardi Koh SOSL searching outside Name Fields?
So according to the documentation, SOSL can be instructed to search within limited types of text fields using the 'IN' clause
much like so:
FIND {"Test*"} IN NAME FIELDS RETURNING Product2 (Id, Name)
for example and according to the same documentation, this should return the results from Product2 that contain the word "test" or very close to it... within the Name field (no additional fields are searched according to the list for Product2)
The behavior within the instance i tested however did not follow this, and the SOSL instead behaves much like it's default state where it seaches in 'ALL FIELDS' mode,
it is returning results where the Name field of Product2 most definitely do not contain the characters in question, but the character sequence does exist in a custom field within Product2.
Is there something missing within the syntax usage of the SOSL that i have missed that is somehow altering the behavior in this manner?
much like so:
FIND {"Test*"} IN NAME FIELDS RETURNING Product2 (Id, Name)
for example and according to the same documentation, this should return the results from Product2 that contain the word "test" or very close to it... within the Name field (no additional fields are searched according to the list for Product2)
The behavior within the instance i tested however did not follow this, and the SOSL instead behaves much like it's default state where it seaches in 'ALL FIELDS' mode,
it is returning results where the Name field of Product2 most definitely do not contain the characters in question, but the character sequence does exist in a custom field within Product2.
Is there something missing within the syntax usage of the SOSL that i have missed that is somehow altering the behavior in this manner?