Hard Coding Wildcard for Search

[Rjrobinson]

Where would you hard code a "%" wildcard into the Leads module for searches on an Account Name for 5.2?
I've found other references to this but they seem to apply to older versions.

Thanks for the help...

[andopes]

Hi Robinson

Actually what do you want to do?

Cheers

[Rjrobinson]

I want to be able to search for an account in the Leads module for any instance of a string or partial string. Right now I am using the "%" to accomplish this.

I would like to hard code this into the search since most of my searches are done this way.

Thanks for the help...

[optsysonl]

Any updates? where you able to resolve this?

[eggsurplus]

Check out include/SearchForm/SearchForm2.php and look around line 751 for the "case 'like'" area. You can add the wild card before and after the search string:

                             case 'like':
                                if($type == 'bool' && $field_value == 0) {
                                    $where .=  $db_field . " = '0' OR " . $db_field . " IS NULL";
                                }
                                else {
                                    $where .=  $db_field . " like '%".$field_value.$like_char."%'";
                                }
                                break; 
  

BTW - This isn't upgrade safe and will be lost on any upgrades so if you do this make sure to mark the code so that you can find any not-upgrade-safe code in the future. It'll save you many headaches!

[pucky900]

You are the Sugar Hero... didn't think it would be that easy. Works perfectly. Much Thanks!

[swiety79]

Thanks eggsurplus! It works just great!