Search only works for first word in a field?

[mccon1]

Hi,

I am using the Sugar Community Edition Version 5.2.0i (Build 5757).

When I have a company which is called for example "General Electric", it is possible to find it with the search query "General", but when I search for "Electric", I don't get any results. Can I change this somehow?

regards,
mccon1

[salesagility]

The SugarCRM wild card is "%"

So, search for "%electric"

and it will find everthing with electric anywhere in the title

[mccon1]

Great, thanks!

But I'd like to to have it integrated automatically with every search, so I edited the /modules/Home/UnifiedSearchAdvanced.php:

In about line 134, right after

if(!empty($_REQUEST['query_string'])) {
// MFH BUG 15404: Added support to trim off whitespace at the beginning and end of a search string
$_REQUEST['query_string'] = trim($_REQUEST['query_string']);

I added this line:

$_REQUEST['query_string'] = "%".$_REQUEST['query_string']; // Better wildcard search

Now it works great if I use the global search box on the top right of every page. But if I use the search on the "Accounts" page, it isn't working. Where do I have to edit? I tried the /modules/Accounts/Account.php in about line 345, inside the "build_generic_where_clause" function, but it didn't work. Any suggestions?

regards,
mccon1

[mccon1]

Any Ideas?

regards,
mccon1

[andopes]

Your approach is not upgrade safe, what means after upgrading your sugar these files can be overridden by a fixed one and your customization will be lost.
You can consider creating a logic_hook after retrieve on Users module to add the "%" before the filters from Basic and Advanced Search.

Regards