X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=SL%2FSEPA.pm;h=2809063077d8b7b3db418f47c74cabda7614af46;hb=2134f89abb07c18b07b3121e80d243af03ede0e0;hp=2b5738d6e74e2882aee35c10d7bac996c088b03a;hpb=003d4959b86170552ee07fd964baedd150165b35;p=kivitendo-erp.git diff --git a/SL/SEPA.pm b/SL/SEPA.pm index 2b5738d6e..280906307 100644 --- a/SL/SEPA.pm +++ b/SL/SEPA.pm @@ -322,12 +322,12 @@ sub list_exports { if ($filter->{invnumber}) { push @where_sub, "arap.invnumber ILIKE ?"; - push @values_sub, '%' . $filter->{invnumber} . '%'; + push @values_sub, like($filter->{invnumber}); $joins_sub{$arap} = 1; } if ($filter->{message_id}) { - push @values, '%' . $filter->{message_id} . '%'; + push @values, like($filter->{message_id}); push @where, <{vc}) { push @where_sub, "vc.name ILIKE ?"; - push @values_sub, '%' . $filter->{vc} . '%'; + push @values_sub, like($filter->{vc}); $joins_sub{$arap} = 1; $joins_sub{vc} = 1; }