Hi, when i use a global search the query is:
like 'string%'It’s true?
How can i change it in:
like '%string%'Thanks.
Where can i find the query used in global search ?
I try to modifie /modules/Home/UnifiedSearchAdvanced.php
Hello,
take a look in config.php -> there you can set $sugar_config [ ’ search_wildcard_infront ’ ] = true;
2 Likes
Another thing…
save_query
By default, list views in Sugar remember the last search performed by the current user in each module. While this can be convenient, it is sometimes unnecessary. If the last search performed in a module was an extensive search, the next time the user navigates to that module will inadvertently perform the search again. This can have a negative impact on performance in Sugar.
Type: String: ‘populate_only’, ‘all’, ‘no’
Versions: 5.2.0+
Editions: CE, Pro, Ent, Corp, and Ult
Override Example:
$sugar_config[ ’ save_query ’ ] = ‘populate_only’;
search_wildcard_char
Set the following values in the $sugar_config [ ’ save_query ’ ]
value in the config_override.php file to configure different options for saving list view queries:
Type: String: Search symbol
Versions: 6.4.3+
Editions: CE, Pro, Corp, Ent, and Ult
Override Example:
$sugar_config [ ’ search_wildcard_char ’ ] = ‘*’;
2 Likes
Hi
I like this $sugar_config[ ’ save_query ’ ] = ‘populate_only’; and it works except it doesn’t clear the previous search term from the fields, is there any easy way of doing that too?
Thanks
Perfect !!
Thanks.