From 9287c2ab25a6c86b17b95945f3304a9f589a0426 Mon Sep 17 00:00:00 2001 From: =?utf8?q?Jan=20B=C3=BCren?= Date: Fri, 13 Aug 2021 08:33:46 +0200 Subject: [PATCH] =?utf8?q?Suche=20nach=20Bemerkung=20in=20EK-Rechnung,=20f?= =?utf8?q?indet=20jetzt=20auch=20Gro=C3=9Fbuchstaben?= MIME-Version: 1.0 Content-Type: text/plain; charset=utf8 Content-Transfer-Encoding: 8bit --- SL/AP.pm | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) 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}) { -- 2.20.1