Auto wildcard %

[LBento]

Hi guys,

I needed that the Basic Search auto assume that it has % (wildcards) at the beggining and at the end of the string I enter.

I can not find the .php file/where to edit it. I believe it should be quite easy as it should be add % at the query that takes the string.

Please help

[mikesolomon]

Have a look at include/SearchForm/SearchForm/SearchForm2.php

I did this by adding the following line after case 'like'

if (! preg_match('/\%/',$field_value) && $type != 'bool') $field_value = '%' . $field_value . '%';

[robertbmirth]

Any idea how to do this in an upgrade safe manner?

[LBento]

What about custom fields, do they get in this page SearchForm2.php?

[LBento]

I wanted to add auto wildcard % to all the fields anyway I can insert that codeline to make it count for all the fields?

Thank you

[SaintAnthony]

It does seem to work for all fields, I inserted the code like this:

case 'like':
if (! preg_match('/\%/',$field_value) && $type != 'bool') $field_value = '%' . $field_value . '%';
if($type == 'bool' && $field_value == 0) { $where .= $db_field . " = '0' OR " . $db_field . " IS NULL";

Hope that helps!

[ckd1987]

Have a look at include/SearchForm/SearchForm/SearchForm2.php

I did this by adding the following line after case 'like'

if (! preg_match('/\%/',$field_value) && $type != 'bool') $field_value = '%' . $field_value . '%';

this is working in Sugar CRM 6.4.RC3

Row 939

case 'like':
if (! preg_match('/\%/',$field_value) && $type != 'bool') $field_value = '%' . $field_value . '%';