Changeset 35929 for trunk/ippTools/share/camtool_pendingexp.sql

Timestamp:

Aug 9, 2013, 1:31:13 PM (13 years ago)

Author:

bills

Message:

in camtool -pendingexp do not list camRuns in state update that have faulted or have bad quality

File:

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

trunk/ippTools/share/camtool_pendingexp.sql

@@ -23 +23 @@
 WHERE
     chipRun.state = 'full'
-    AND ((camRun.state = 'new' AND camProcessedExp.cam_id IS NULL) OR camRun.state = 'update')
+    AND ((camRun.state = 'new' AND camProcessedExp.cam_id IS NULL) OR
+         (camRun.state = 'update' and camProcessedExp.fault = 0 and camProcessedExp.quality = 0))
     AND camMask.label IS NULL
     AND (Label.active OR Label.active IS NULL)