Changeset 24902 for branches/czw_branch/cleanup/ippTools/share/dettool_pendingcleanup_processedimfile.sql

Timestamp:

Jul 22, 2009, 4:48:49 PM (17 years ago)

Author:

watersc1

Message:

New sql files to correctly select out files that are pending or done
with cleanup. This returns files marked as purged and scrubbed as
well as simpled cleaned.

Typo fixes in ipp_cleanup.pl .

File:

• branches/czw_branch/cleanup/ippTools/share/dettool_pendingcleanup_processedimfile.sql (modified) (1 diff)

branches/czw_branch/cleanup/ippTools/share/dettool_pendingcleanup_processedimfile.sql

@@ -7 +7 @@
     USING(det_id)
 WHERE
-    detRunSummary.data_state = 'goto_cleaned'
-AND detProcessedImfile.data_state = 'full'
+    ((detRunSummary.data_state = 'goto_cleaned'
+      AND detProcessedImfile.data_state = 'full')
+     OR (detRunSummary.data_state = 'goto_scrubbed'
+         AND detProcessedImfile.data_state = 'full')
+     OR (detRunSummary.data_state = 'goto_purged'
+         AND detProcessedImfile.data_state = 'full')
+     OR detProcessedImfile.data_state = 'goto_cleaned'
+     OR detProcessedImfile.data_state = 'goto_scrubbed'
+     OR detProcessedImfile.data_state = 'goto_purged')