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?
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 config_override.php options:
$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.
2 Likes