Changeset 36071 for branches/eam_branches/ipp-20130711/ippTools/share/camtool_pendingexp.sql

Timestamp:

Aug 30, 2013, 4:48:58 PM (13 years ago)

Author:

eugene

Message:

updates from trunk

Location:

branches/eam_branches/ipp-20130711/ippTools/share

Files:

• . (modified) (1 prop)
• camtool_pendingexp.sql (modified) (1 diff)

branches/eam_branches/ipp-20130711/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)