Index: APPS/Halux/PPS/TBXZaag/impl/Werkpost.cls.xml
===================================================================
diff -u -r3180 -r3219
--- APPS/Halux/PPS/TBXZaag/impl/Werkpost.cls.xml	(.../Werkpost.cls.xml)	(revision 3180)
+++ APPS/Halux/PPS/TBXZaag/impl/Werkpost.cls.xml	(.../Werkpost.cls.xml)	(revision 3219)
@@ -36,7 +36,7 @@
 <ReturnType>%XML.DataSet</ReturnType>
 <Implementation><![CDATA[
 	;Set Log=..Logger.Debug("GeefBatchLijst", "Lijn:"_$G(Output2Lijn))
-	Set DataSet=##class(%XML.DataSet).%New("APPS.Halux.PPS.TBXZaag.impl.LijstHelper:qActieveBatchLijst")
+	Set DataSet=##class(%XML.DataSet).%New("APPS.Halux.PPS.TBXZaag.impl.LijstHelper:qActieveBeperkteBatchLijst")
 	
 	Quit DataSet
 ]]></Implementation>
Index: APPS/Halux/PPS/TBXZaag/impl/LijstHelper.cls.xml
===================================================================
diff -u -r3217 -r3219
--- APPS/Halux/PPS/TBXZaag/impl/LijstHelper.cls.xml	(.../LijstHelper.cls.xml)	(revision 3217)
+++ APPS/Halux/PPS/TBXZaag/impl/LijstHelper.cls.xml	(.../LijstHelper.cls.xml)	(revision 3219)
@@ -23,7 +23,7 @@
 <MultiDimensional>1</MultiDimensional>
 </Property>
 
-<Query name="qActieveBatchLijst">
+<Query name="qActieveBeperkteBatchLijst">
 <Type>%SQLQuery</Type>
 <FormalSpec>LijnNr</FormalSpec>
 <SqlQuery><![CDATA[	Select Batch || '||' || isnull(SubBatch,'') as BatchKey, Batch || ' ' || isnull(SubBatch,'') as BatchOms,Batch || ' ' || isnull(SubBatch,'') || ' - nog ' || sum(case status when 'W' then 1 else 0 end) || ' van ' || count(*) as BatchLangeOms 
@@ -35,6 +35,17 @@
 <Parameter name="CONTAINID" value="0"/>
 </Query>
 
+<Query name="qActieveBatchLijst">
+<Type>%SQLQuery</Type>
+<FormalSpec>LijnNr</FormalSpec>
+<SqlQuery><![CDATA[	Select Batch || '||' || isnull(SubBatch,'') as BatchKey, Batch || ' ' || isnull(SubBatch,'') as BatchOms,Batch || ' ' || isnull(SubBatch,'') || ' - nog ' || sum(case status when 'W' then 1 else 0 end) || ' van ' || count(*) as BatchLangeOms 
+	from APPS_Halux_PPS_TBXZaag.Opdrachten
+	where isnull(Batch,0)<>0
+	and Batch->IsActief=1
+	group by Batch,SubBatch]]></SqlQuery>
+<Parameter name="CONTAINID" value="0"/>
+</Query>
+
 <Query name="qZaagLijst">
 <Type>%Query</Type>
 <FormalSpec>BatchID:%Integer,SubBatch:APPS.Halux.PPS.TBXZaag.enu.SubBatch</FormalSpec>