X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=SL%2FController%2FTopQuickSearch%2FContact.pm;h=e170524ab6eec41c18c76be0a4cdbc7edffe7de6;hb=78078fbf7a94e349032c83ae324c87c94487e11a;hp=5607a5b8296e8bfead09a97565c2be5ba37d67be;hpb=6c63020409f486043d63c3a324db96a4a162ff67;p=kivitendo-erp.git diff --git a/SL/Controller/TopQuickSearch/Contact.pm b/SL/Controller/TopQuickSearch/Contact.pm index 5607a5b82..e170524ab 100644 --- a/SL/Controller/TopQuickSearch/Contact.pm +++ b/SL/Controller/TopQuickSearch/Contact.pm @@ -5,7 +5,7 @@ use parent qw(SL::Controller::TopQuickSearch::Base); use SL::Controller::CustomerVendor; use SL::DB::Vendor; -use SL::DBUtils qw(selectfirst_array_query); +use SL::DBUtils qw(selectfirst_array_query like); use SL::Locale::String qw(t8); sub auth { 'customer_vendor_edit' } @@ -22,9 +22,9 @@ sub query_autocomplete { my $result = SL::DB::Manager::Contact->get_all( query => [ or => [ - cp_name => { ilike => "%$::form->{term}%" }, - cp_givenname => { ilike => "%$::form->{term}%" }, - cp_email => { ilike => "%$::form->{term}%" }, + cp_name => { ilike => like($::form->{term}) }, + cp_givenname => { ilike => like($::form->{term}) }, + cp_email => { ilike => like($::form->{term}) }, ], cp_cv_id => [ \'SELECT id FROM customer UNION SELECT id FROM vendor' ], ],