X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=sql%2FPg-upgrade2%2Ferzeugnisnummern.pl;h=8468e6922e3e8fbe29241d26d3a33aba36964f92;hb=4a98a42369087fe9d291285690bca812e9815c8a;hp=bd8eb1cd8b65cf6ffd03c19ca963347f85028ade;hpb=bed19453fb654f69ad972911a4533ca89f8ae0c9;p=kivitendo-erp.git diff --git a/sql/Pg-upgrade2/erzeugnisnummern.pl b/sql/Pg-upgrade2/erzeugnisnummern.pl index bd8eb1cd8..8468e6922 100644 --- a/sql/Pg-upgrade2/erzeugnisnummern.pl +++ b/sql/Pg-upgrade2/erzeugnisnummern.pl @@ -79,16 +79,15 @@ sub filter_parts { } if ($::form->{filter_type} eq 'assembly') { - $where .= ' AND assembly'; + $where .= " AND part_type = 'assembly'"; } if ($::form->{filter_type} eq 'service') { - $where .= ' AND inventory_accno_id IS NULL AND NOT assembly'; + $where .= " AND part_type = 'service'"; } if ($::form->{filter_type} eq 'part') { - $where .= ' AND inventory_accno_id IS NOT NULL'; - $where .= ' AND NOT assembly'; + $where .= " AND part_type = 'part'"; } if ($::form->{filter_obsolete} eq 'obsolete') {