How to improve search functionality in SuiteCRM 8.2 without using ElasticSearch

💬 General Discussion
1

Hello everyone,

I just installed SuiteCRM 8.2 on my server and I am discovering this great solution. However, I have a problem with searching in the application. I find that it is not possible to get results similar to a “LIKE %%” SQL query, and it seems that we have to know the beginning of a contact or account to be able to find it.

Example -

  • Account name : APHP HĂ´pital
    Can be found with “ap” letters but no result with “hp” letters only.

I have seen that SuiteCRM 8 can be improved with ElasticSearch, but this solution seems to be very resource-consuming (at least 16 GB) and it is beyond my means to set up a dedicated server of this type at the moment.

Has anyone ever encountered this problem and found a way to bypass this search limitation? I am really interested in any ideas and tips you may have on this topic.

Thank you in advance for your help!

2

Did you try the following optin in config.php?
‘search_wildcard_infront’ => true,

2 Likes
3

Thanks a lot, it was the option needed :slight_smile:

4

Are there any other methods to improve search without Elashticsearch? :thinking:

5

I often have to add some fields to the global search. Unfortunately, that’s via code only:

And then, there are the search settings in the admin area, which might help in specific cases:

image
image1603×1105 69.5 KB

1 Like