Troubleshooting witch search zone

[admincesium]

Hello,
I have deployed SuiteCRM 8.1.3 in Xampp.
I imported 50000 accounts in my database.
When I type an account, identicaly wrote in the database, in a search zone (global or in the filter), I received the result.
When I type a part of an account in a search zone, I received no result.
Have you ever seen this problem ?
Thanks for your help

[pgr]

Hi, welcome to the Community!

Try adding the wildcard character %

So if you have an account called “Big Name” you should be able to search for it with “Big%”

[admincesium]

Hi,
thanks for your answer.
It works but It searchs by “begin with” and I want a search by “contains”

[pgr]

Try “%Big%”, it should work

[pgr]

You can make that behaviour default

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 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.

[admincesium]

Thanks a lot.
It works very well !!