UnifiedSearch wildcard

[brob]

Hi does anyone know how to change the unified search file (modules/home/unifiedsearch.php) which appears on all pages as the general search field.

I need this to automatically add the % search variable

cheers in advance

[Superman]

Haven't you seen how the search is being arranged now? There are calls to modules' functions.

[brob]

Hi,

Yeah I've been into the modules and added the % but that doesnt seem to work. Any other ideas?

[Superman]

Can you list here the result queries? (i mean queries itself, not the result of the query)

[brob]

this is a line from the accounts ListView module

     if(isset($name) && $name != "") array_push($where_clauses, "accounts.name like '%".PearDatabase::quote($name)."%'"); 
  

so to search for the accounts name, if i were to search for amazing it would return two different companies i.e. 'amazing company' and 'the amazing future'

at present it wont return 'the amazing future' only 'amazing company'

[Superman]

Can you provide here such a string (query):
SELECT ....;

[westowl]

not sure if this is the answer you're looking for, but in UnifiedSearchAdvanced.php, look for

$clause .= "LIKE '{$_REQUEST['query_string']}%'";

add % before {$_REQUEST

[sugarcare]

how about searching more than 1 string like any search engine. For instance strings such as

technology solution

provides all records that has both strings appearing in the record...

[tomkerswill]

I would also like to see what sugarcare mentioned in the post above. A simple example is - I have a lead called "Chris Middleton"

Searching for "Chris Middleton" brings up nothing - because first_name=Chris and last_name=Middleton. Need to search both fields at once really!

Tom

[simple]

Hi

I didn't test it yet but maybe the change provided by ivangool in this post helps.