X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=SL%2FAP.pm;h=a77906c96ecfd5595fec4e3ff4ce8b6df629f6da;hb=332e327b6613bf762b34d841442378de255d946b;hp=601083b8de75da94bf77f3907a97018dc55681b5;hpb=a0b82b1e7a9fab32f162ebee5031913b2f44ed5a;p=kivitendo-erp.git diff --git a/SL/AP.pm b/SL/AP.pm index 601083b8d..a77906c96 100644 --- a/SL/AP.pm +++ b/SL/AP.pm @@ -546,7 +546,7 @@ sub ap_transactions { push(@values, like($form->{transaction_description})); } if ($form->{notes}) { - $where .= " AND lower(a.notes) LIKE ?"; + $where .= " AND a.notes ILIKE ?"; push(@values, like($form->{notes})); } if ($form->{project_id}) {