The index-based search returns results for substrings only if they are at the beginning of a word (see table).
It is expected that the index search will also yield results if the search string is within a word. Analogous to the SQL search with like '% ...%'.
Can the system be configured accordingly?
Thanks for any reply :)
Christian
search string | Results by index search in web portal | Results by SQL-Search in Object Browser |
Officer | Compliance Officer Investigation | Compliance Officer Investigation |
Off | Compliance Officer Investigation | Compliance Officer Investigation |
cer | -- | Compliance Officer Investigation |
D-BOABS | D-BOABS-API-A | D-BOABS-API-A |
API | -- | D-BOABS-API-A |