X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=SL%2FIR.pm;h=98a53536f97f6f735ccb2b2252d9991370b80d53;hb=7783c24d2a5f3f7413dc18d5b96b8a98995ac7da;hp=875059bfacf397090bbb1244042671abd08481b2;hpb=d94820d09f4848d06bf3b74bb85c2c52820fbc48;p=kivitendo-erp.git diff --git a/SL/IR.pm b/SL/IR.pm index 875059bfa..98a53536f 100644 --- a/SL/IR.pm +++ b/SL/IR.pm @@ -1007,7 +1007,7 @@ sub retrieve_item { foreach my $table_column (qw(p.partnumber p.description pg.partsgroup)) { my $field = (split m{\.}, $table_column)[1]; next unless $form->{"${field}_${i}"}; - $where .= " AND lower(${table_column}) LIKE ?"; + $where .= " AND lower(${table_column}) LIKE lower(?)"; push @values, '%' . $form->{"${field}_${i}"} . '%'; }