Changeset 24883 for trunk/ippTools/share/magicdstool_torevert_camera.sql

Timestamp:

Jul 21, 2009, 2:42:19 PM (17 years ago)

Author:

bills

Message:

Added mode to magictool to censor a magicRun. This is used if unmasked streaks
are found.
This causes any magicDSRuns associated to have the state set to censored
and any de-streaked files to be queued for reverting.

File:

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

trunk/ippTools/share/magicdstool_torevert_camera.sql

@@ -19 +19 @@
     JOIN rawExp using(exp_id)
 WHERE magicDSRun.stage = 'camera'
-    AND magicDSRun.state = 'new'
+    AND (magicDSRun.state = 'new' OR magicDSRun.state = 'censored')
     AND magicDSFile.fault > 0