Changeset 30239

Timestamp:

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

Author:

bills

Message:

all camera run to be destreaked if associated chipRun was magicked before
it was cleaned

File:

• tags/ipp-20101215/ippTools/share/magicdstool_todestreak_camera.sql (modified) (1 diff, 1 prop)

tags/ipp-20101215/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