Verkauf/Rechnungen/Massenerstellung: keine Zahlungsbedingungen

[mfinanz.git] / SL / CVar.pm

diff --git a/SL/CVar.pm b/SL/CVar.pm
index f134812079afe59d74faf7b329bd4fd06f4e687b..3dba8b217d009453697f57540aa1a8940b1b8637 100644 (file)
--- a/SL/CVar.pm
+++ b/SL/CVar.pm
@@ -356,7 +356,7 @@ sub build_filter_query {
       next unless ($params{filter}->{$name});
 
       push @sub_where,  qq|cvar.text_value ILIKE ?|;
-      push @sub_values, '%' . trim($params{filter}->{$name}) . '%'
+      push @sub_values, like($params{filter}->{$name});
 
     } elsif ($config->{type} eq 'select') {
       next unless ($params{filter}->{$name});
@@ -419,12 +419,12 @@ sub build_filter_query {
 
       my $table = $config->{type};
       push @sub_where, qq|cvar.number_value * 1 IN (SELECT id FROM $table WHERE name ILIKE ?)|;
-      push @sub_values, "%" . trim($params{filter}->{$name}) . "%";
+      push @sub_values, like($params{filter}->{$name});
     } elsif ($config->{type} eq 'part') {
       next unless $params{filter}->{$name};
 
       push @sub_where, qq|cvar.number_value * 1 IN (SELECT id FROM parts WHERE partnumber ILIKE ?)|;
-      push @sub_values, "%" . trim($params{filter}->{$name}) . "%";
+      push @sub_values, like($params{filter}->{$name});
     }
 
     if (@sub_where) {