Changeset 19558 for trunk/ippTools/share/camtool_find_pendingexp.sql

Timestamp:

Sep 15, 2008, 2:21:00 PM (18 years ago)

Author:

bills

Message:

changes to support cleanup, purge, and update processing

File:

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

trunk/ippTools/share/camtool_find_pendingexp.sql

@@ -25 +25 @@
     WHERE
         chipRun.state = 'full'
-        AND camRun.state = 'new'
+        AND ((camRun.state = 'new' AND camProcessedExp.cam_id IS NULL)
+            OR camRun.state = 'update')
         AND camMask.label IS NULL
-        AND camProcessedExp.cam_id IS NULL
     ) as Foo