projects
/
kivitendo-erp.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
doc/ Trigram Erweiterung als Musskriterium für das Upgrade genannt
[kivitendo-erp.git]
/
SL
/
Common.pm
diff --git
a/SL/Common.pm
b/SL/Common.pm
index
f6a7267
..
b70378e
100644
(file)
--- a/
SL/Common.pm
+++ b/
SL/Common.pm
@@
-67,14
+67,14
@@
sub retrieve_parts {
}
if ($form->{no_assemblies}) {
}
if ($form->{no_assemblies}) {
- $filter .= qq| AND (NOT
COALESCE(assembly, FALSE)
)|;
+ $filter .= qq| AND (NOT
part_type = 'assembly'
)|;
}
if ($form->{assemblies}) {
}
if ($form->{assemblies}) {
- $filter .= qq| AND
assembly=TRUE
|;
+ $filter .= qq| AND
part_type = 'assembly'
|;
}
if ($form->{no_services}) {
}
if ($form->{no_services}) {
- $filter .= qq| AND
(inventory_accno_id is not NULL or assembly=TRUE
)|;
+ $filter .= qq| AND
NOT (part_type = 'service' OR part_type = 'assembly'
)|;
}
substr($filter, 1, 3) = "WHERE" if ($filter);
}
substr($filter, 1, 3) = "WHERE" if ($filter);