Expression Rule operator "starts with" not working
When trying to setup boost expression or filter rule for a coveo search tab in sitecore, any operator other than "is equal to" or "is not equal to" is not working for me when I make the comparison for a sitecore item field. My requirement is to check if the field value is starting with a character and hence moving towards "starts with" operator but it does not fetch any results. Please help what could be wrong.
The "starts with", "ends with", and "contains" operators are using the wildcard query operator under the hood. When using wildcards, both conditions must be met:
- The field must be set as facet.
- The query term must contain at least 2 valid characters. For example `@field *= "a*"` would not work but `@field *= "ar*"` would.
EDIT: There is no constraint on the minimum number of characters when the wildcard is used to query a field. However, the constraint is enforced when the wildcard is used in a regular query term.
I would encourage you to try with some manual queries in the Content Browser and see how it goes.
You can find some more information on wildcards in this topic.
I hope this helps