Index: TAOR rework/TAOR rework/TAOR rework.vbproj =================================================================== diff -u -r1954 -r1955 --- TAOR rework/TAOR rework/TAOR rework.vbproj (.../TAOR rework.vbproj) (revision 1954) +++ TAOR rework/TAOR rework/TAOR rework.vbproj (.../TAOR rework.vbproj) (revision 1955) @@ -29,7 +29,7 @@ TAOR rework Robin De Bock false - 4 + 5 6.1.6.%2a false true Index: TAOR rework/TAOR rework/databases/Automilling/AutomillingMapper.vb =================================================================== diff -u -r1954 -r1955 --- TAOR rework/TAOR rework/databases/Automilling/AutomillingMapper.vb (.../AutomillingMapper.vb) (revision 1954) +++ TAOR rework/TAOR rework/databases/Automilling/AutomillingMapper.vb (.../AutomillingMapper.vb) (revision 1955) @@ -365,7 +365,9 @@ Const queryProduction = " SELECT PickSequence, PickPlace, PalletID, SlotNbr, LeftRight, FeedbackERP, PickTimeStamp, MillingTimeStamp, DropTimeStamp, InsertTimeStamp, BatchID, SequenceNbr, ProductCode, Color, PickListID, NettoLength, NettoHeight, OversizeLength, OversizeHeight, ProgramLeftInner, ProgramLeftOuter, ProgramRightInner, ProgramRightOuter, PrintBarcodeLeft, PrintBarcodeRight, PrintTextLeft1, PrintTextLeft2, PrintTextLeft3, PrintTextRight1, PrintTextRight2, PrintTextRight3, PrintTextLeft4, PrintTextRight4, tablework, adjustment_X1, adjustment_X2, adjustment_YA, adjustment_YB, adjustment_YC, adjustment_YD FROM [Automilling].[dbo].[Production] - where PickTimeStamp IS NOT NULL and MillingTimeStamp IS NULL" + where PickTimeStamp IS NOT NULL + and MillingTimeStamp IS NULL + and 2 > DATEDIFF(DAY,PickTimeStamp, GETDATE())" Const queryHistory = " SELECT PickSequence, PickPlace, PalletID, SlotNbr, LeftRight, FeedbackERP, PickTimeStamp, MillingTimeStamp, DropTimeStamp, InsertTimeStamp, BatchID, SequenceNbr, ProductCode, Color, PickListID, NettoLength, NettoHeight, OversizeLength, OversizeHeight, ProgramLeftInner, ProgramLeftOuter, ProgramRightInner, ProgramRightOuter, PrintBarcodeLeft, PrintBarcodeRight, PrintTextLeft1, PrintTextLeft2, PrintTextLeft3, PrintTextRight1, PrintTextRight2, PrintTextRight3, PrintTextLeft4, PrintTextRight4, tablework, adjustment_X1, adjustment_X2, adjustment_YA, adjustment_YB, adjustment_YC, adjustment_YD FROM [Automilling].[dbo].[History]