Changeset 30238

Timestamp:

Jan 12, 2011, 11:10:02 AM (15 years ago)

Author:

bills

Message:

Allow camera run to be destreaked if chipRun is cleaned but was magicked.

File:

• trunk/ippTools/share/magicdstool_todestreak_camera.sql (modified) (1 diff)

trunk/ippTools/share/magicdstool_todestreak_camera.sql

@@ -38 +38 @@
     AND magicDSRun.stage = 'camera'
     AND camRun.state = 'full'
-    AND chipRun.state = 'full'
-    AND chipRun.magicked
+    AND ((chipRun.state = 'full' AND chipRun.magicked > 0) 
+         OR (chipRun.state = 'cleaned' AND chipRun.magicked < 0)) 
     AND camProcessedExp.fault = 0
     AND camProcessedExp.quality = 0