Index: BL/PPS/WPLosOnderdeel.cls.xml
===================================================================
diff -u -r32575 -r38442
--- BL/PPS/WPLosOnderdeel.cls.xml (.../WPLosOnderdeel.cls.xml) (revision 32575)
+++ BL/PPS/WPLosOnderdeel.cls.xml (.../WPLosOnderdeel.cls.xml) (revision 38442)
@@ -34,7 +34,7 @@
INTO :QueueID
FROM PPS.TBX_Queue
WHERE BatchID= :BatchID and Status='W' and WPLosOnderdeel_WPStatus='W'
- ORDER BY Sequence)
+ ORDER BY SorteerSleutel,Sequence)
Quit QueueID
]]>
@@ -56,7 +56,7 @@
INTO :QueueID
FROM PPS.TBX_Queue
WHERE BatchID= :BatchID and Status='W' and WPLosOnderdeel_WPStatus='W' and Sequence>:Sequence
- ORDER BY Sequence)
+ ORDER BY SorteerSleutel,Sequence)
Quit QueueID
]]>
@@ -152,7 +152,7 @@
FROM PPS.TBX_Queue as Q
JOIN APPS_Halux_common_impl.BatchImpl as B on B.ID=Q.BatchID
WHERE BatchID=:BatchID and (WPLosOnderdeel_WPStatus is not null and WPLosOnderdeel_WPStatus <> 'X')
- ORDER BY Sequence]]>
+ ORDER BY SorteerSleutel,Sequence]]>
@@ -206,7 +206,7 @@
#dim IDs As %ListOfDataTypes = ##class(%ListOfDataTypes).%New()
#dim ResultSet As TECH.ResultSet = ##class(TECH.ResultSet).%New()
- Do ResultSet.Prepare("SELECT ID FROM PPS.TBX_Queue WHERE BatchID=? and Status='W' and (WPLosOnderdeel_SnijStatus='W') ORDER BY Sequence")
+ Do ResultSet.Prepare("SELECT ID FROM PPS.TBX_Queue WHERE BatchID=? and Status='W' and (WPLosOnderdeel_SnijStatus='W') ORDER BY SorteerSleutel,Sequence")
Do ResultSet.Execute(BatchID)
While (ResultSet.Next()) {
Index: BL/PPS/TBX/Sequencer.cls.xml
===================================================================
diff -u -r29059 -r38442
--- BL/PPS/TBX/Sequencer.cls.xml (.../Sequencer.cls.xml) (revision 29059)
+++ BL/PPS/TBX/Sequencer.cls.xml (.../Sequencer.cls.xml) (revision 38442)
@@ -302,7 +302,7 @@
Select ID, Product, WPVerpak_KlantSort as KlantSort,WPVerpak_UnitNr as UnitNr,WPVerpak_SubNr as SubNr,WPVerpak_SlotNr as SlotNr, Sequence,Status
from PPS.TBX_Queue
where BatchID=:BatchID
- order by Sequence
+ order by SorteerSleutel,Sequence
@@ -311,7 +311,7 @@
Select ID
from PPS.TBX_Queue
where WPPers_FirstChanged like :Datum
- order by Sequence
+ order by SorteerSleutel,Sequence
Index: BL/PPS/TBX/WPPers.cls.xml
===================================================================
diff -u -r37402 -r38442
--- BL/PPS/TBX/WPPers.cls.xml (.../WPPers.cls.xml) (revision 37402)
+++ BL/PPS/TBX/WPPers.cls.xml (.../WPPers.cls.xml) (revision 38442)
@@ -126,7 +126,7 @@
SELECT ID INTO :ID
FROM PPS.TBX_Queue
WHERE BatchID= :BatchID and Status='W' and WPPers_WPStatus='W'
- ORDER BY Sequence)
+ ORDER BY SorteerSleutel,Sequence)
; WHERE BatchID= :BatchID and Status='W' and WPPers_WPStatus='W'
Quit ID
@@ -149,7 +149,7 @@
INTO :NewID
FROM PPS.TBX_Queue
WHERE BatchID= :BatchID and Status='W' and WPPers_WPStatus='W' and Sequence>:Sequence
- ORDER BY Sequence)
+ ORDER BY SorteerSleutel,Sequence)
Quit $G(NewID)
]]>
@@ -406,7 +406,7 @@
FROM PPS.TBX_Queue as Q
JOIN APPS_Halux_common_impl.BatchImpl as B on B.ID=Q.BatchID
WHERE BatchID=:BatchID and (WPPers_WPStatus is not null and WPPers_WPStatus <> 'X')
- ORDER BY Sequence]]>
+ ORDER BY SorteerSleutel,Sequence]]>
@@ -433,7 +433,7 @@
ProductNr as PRNr
FROM PPS.TBX_Queue as Q
WHERE BatchID=:BatchID and (WPPers_WPStatus is not null and WPPers_WPStatus <> 'X')
- ORDER BY Sequence]]>
+ ORDER BY SorteerSleutel,Sequence]]>
Index: APPS/Halux/PPS/TBXZaag/impl/MaakBatch.cls.xml
===================================================================
diff -u -r34186 -r38442
--- APPS/Halux/PPS/TBXZaag/impl/MaakBatch.cls.xml (.../MaakBatch.cls.xml) (revision 34186)
+++ APPS/Halux/PPS/TBXZaag/impl/MaakBatch.cls.xml (.../MaakBatch.cls.xml) (revision 38442)
@@ -60,7 +60,7 @@
%SQLQuery
BatchID:%Integer
Select %ID from PPS.TBX_Queue where BatchId = :BatchID
- order by Sequence
+ order by SorteerSleutel,Sequence
Index: BL/PPS/TBX/WPZaag.cls.xml
===================================================================
diff -u -r29059 -r38442
--- BL/PPS/TBX/WPZaag.cls.xml (.../WPZaag.cls.xml) (revision 29059)
+++ BL/PPS/TBX/WPZaag.cls.xml (.../WPZaag.cls.xml) (revision 38442)
@@ -55,7 +55,7 @@
SELECT top 1 ID, Sequence INTO :pID, :pSequence
FROM PPS.TBX_Queue
WHERE BatchID= :BatchID and Status='W' and WPZaag_WPStatus='W'
- ORDER BY Sequence)
+ ORDER BY SorteerSleutel,Sequence)
if (SQLCODE'=0) do
. Set pID=""
. Set pSequence=""
@@ -70,7 +70,7 @@
SELECT top 1 ID, Sequence INTO :pID, :pSequence
FROM PPS.TBX_Queue
WHERE BatchID= :BatchID and Sequence> :pSequence and Status='W' and WPZaag_WPStatus='W'
- ORDER BY Sequence)
+ ORDER BY SorteerSleutel,Sequence)
//Do WLIP^vhDBG(139,"SqlCode="_SQLCODE)
if (SQLCODE'=0) do
. Set pID=""