Wildcard in freetext search

lock
push_pin
done
Answered
1

Previously one should/could use % to search for "contains" in company, contact, sale, project etc. Now "contains" is standard and the % is no longer needed. Is it still possible to use % within a name, for instance if you don't remember the exact spelling?

11 Dec 2023 | 08:52 AM

All Replies (1)

If you misspell a word in the navigator search it will attempt to use soundex search to find the sounds-like matches without using %.

The freetext search will do contains search if you prefix a word with % - so a search for "%office" will search for all words that contains "office" - in names and descriptions, but it will be slow - because it has to scan all words in the database.

We index partial words in names - so a search for "office" will find "superoffice" in a company or project name without using %, but it will not find "office" within "superoffice" in descriptions or non-name fields. On the other hand it is much faster than using %.

Freetext search does not currently fall back to soundex searches - so maybe that is something to wish for?

12 Dec 2023 | 09:21 AM

Add reply