Wildcard in freetext search
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?
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?