Hello!
We are seeing an issue with fulltext search, where results that don't exactly match the search term are being returned.
I have read on these forums that the fulltext search is not in any way fuzzy, so this seems v strange.
Examples:
-
- this should only return Stowe House, but matches on Stow Maries too
-
- this should only return Stow Maries, but matches on Stowe House too
-
- this shouldn't return anything but returns both above projects
-
- this doesn't return anything, which is good, but working from above logic shouldn't it return Stow Maries?
For context, this search queries fulltext matches in project title only, and then performs another search to query fulltext in the entire project document.
This is not great behaviour for us because it means the result with an exact match is not the first in the list...
If we're doing something wrong here, or there are other options that we can use to only match exact terms, please let me know!
Thank you,
Jarod