X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=SL%2FDB%2FManager%2FRequirementSpec.pm;h=fecd9d35860254df1b0c66cc9590c05ab79ac9bd;hb=de7609414010f5dfa6c47091633a6319d0106c48;hp=daf9d6bad176f3995cfc0aa4a2236229c68a23fa;hpb=b2e1809f6b6d8852ab0086dcc61ae9540c18b83f;p=kivitendo-erp.git

diff --git a/SL/DB/Manager/RequirementSpec.pm b/SL/DB/Manager/RequirementSpec.pm
index daf9d6bad..fecd9d358 100644
--- a/SL/DB/Manager/RequirementSpec.pm
+++ b/SL/DB/Manager/RequirementSpec.pm
@@ -25,4 +25,15 @@ sub _sort_spec {
     });
 }
 
+sub working_copy_filter {
+  return (working_copy_id => undef);
+}
+
+sub not_empty_filter {
+  my @tables = qw(requirement_spec_items requirement_spec_text_blocks requirement_spec_parts);
+  my @filter = map { \"id IN (SELECT nef_${_}.requirement_spec_id FROM ${_} nef_${_})" } @tables;
+
+  return (or => \@filter);
+}
+
 1;