First, I'll explain how I stumbled upon the issue. We need some serious, working search functionality.
I set up a custom field for cases. I set up the custom field to be searchable.
I then created a test case and populated my new field with latin text "Lorem....".
I then tried to find my new case with case search and "lorem" in my custom field. It couldn't find it.
I then tried to find the new case with the new field using "full-text search". It couldn't find it again. I then started testing full-text search. It seems to be hit and miss.
Perhaps it's user error, and in that case, please advise what I'm doing wrong. I would appreciate it.
For the following tests, I'm using "all tables" and yes, I have wildcards enabled. Full-text search doesn't find "lorem" which is in my case custom field. Full-text search doesn't find "john" which is in the name of several contacts (john, johnson...). Full-text search doesn't find "j" which is in many fields in many tables. Full-text search only finds four hits for "a" which are all names of contacts. Full-text search doesn't find "max" which is in at least four contact's names. Full-text search does find three hits for "bob" all within contact's names. Full-text search does find two hits for "sheep" which are all in case descriptions.
Can anyone shed some light on these inconsistent results?
Thanks so much!