Changeset 34766 for trunk/ippTools/share/chiptool_pendingcleanuprun.sql

Timestamp:

Dec 4, 2012, 3:51:25 PM (13 years ago)

Author:

bills

Message:

Add option -all to -pendingcleanup*file modes. This returns all components
regardless of data state. This will be used to re-run cleanup to pick
up files that were missed previously or were added to the cleanup list (warp and chip cmfs)

File:

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

trunk/ippTools/share/chiptool_pendingcleanuprun.sql

@@ -1 @@
-SELECT
+SELECT DISTINCT
     chipRun.chip_id,
     rawExp.camera,
-    chipRun.state
+    rawExp.exp_tag,
+    chipRun.state,
+    chipRun.workdir
 FROM chipRun
 JOIN rawExp