Our database has lots of text, lots of information.
But the lack of being able to specify what is a key index field parameters is starting to drain me.
For example SURNAME GIVEN NAMES are of primary interest.
But mentions of the name or part of the name in someone else’s name is not.
Example SMITH Specific surname.
Yes I can specify in a filter surname IS smith AND ONLY GET SURNAME SMITH RESULTS
But at the user level they get a search box and the results end up including names like ARROWSMITH SMITHFIELD SMITHON and guys who were born in SMITHVILLE, SMITHOWN etc. (see image)
It is indeed powerful to have an all encompassing search facility BUT IT IS COUNTER PRODUCTIVE to my way of thinking and probably the reverse of what I would like IN A SEARCH facility which to my programming background is normally reserved for specific index searching.
I would much rather do a “search everything” click to have it search all fields for occurences and stick to specific INDEX FIELDS for normal (in effect is what “contains” selection in filters does.
Be interested in other experiences and viewpoints