When I search and filter by Customer Name in List View, I want it to search more rigorously. For example, If I have a customer named “Michael Alfred”, I want the search to match for search keywords including “MICHAEL”, “alfred” and “fred”. I want the search to be match many as much as possible. Any advice on how to accomplish this?
Advanced Search of a snippet throughout a Name
Search should be case-insensitive by default.
For the partial searches, try using a
% wildcard character.
If you need to configure it, search these forums for these
$sugar_config['search_wildcard_char'] = '%'; $sugar_config['search_wildcard_infront'] = true;
Finally, you might want to set up an Elastic Search server connected to your database and get a lot more search functionality.