Changeset 19528

Timestamp:

Sep 11, 2008, 3:34:47 PM (18 years ago)

Author:

bills

Message:

include runs in goto_purged state in the pending lists

Location:

trunk/ippTools/share

Files:

• camtool_pendingcleanupexp.sql (modified) (1 diff)
• camtool_pendingcleanuprun.sql (modified) (1 diff)

trunk/ippTools/share/camtool_pendingcleanupexp.sql

@@ -13 +13 @@
     USING(cam_id)
 WHERE
-    camRun.state = 'goto_cleaned'
+    (camRun.state = 'goto_cleaned' OR camRun.state = 'goto_purged')
+

trunk/ippTools/share/camtool_pendingcleanuprun.sql

@@ -9 +9 @@
 USING (exp_id)
 WHERE
-    camRun.state = 'goto_cleaned'
+    (camRun.state = 'goto_cleaned' OR camRun.state = 'goto_purged')