Changeset 42207 for branches/eam_branches/ipp-20220316/ippTools/share/fpcamtool_pendingexp.sql

Timestamp:

May 17, 2022, 3:30:24 PM (4 years ago)

Author:

eugene

Message:

add fpcamtool support

File:

• branches/eam_branches/ipp-20220316/ippTools/share/fpcamtool_pendingexp.sql (modified) (2 diffs)

branches/eam_branches/ipp-20220316/ippTools/share/fpcamtool_pendingexp.sql

@@ -18 +18 @@
 LEFT JOIN fpcamProcessedExp
     USING(fpcam_id)
-LEFT JOIN fpcamMask
-    ON fpcamRun.label = fpcamMask.label
 LEFT JOIN Label
     ON fpcamRun.label = Label.label
@@ -25 +23 @@
     chipRun.state = 'full'
     AND camRun.state = 'full'
-    AND ((fpcamRun.state = 'new'    AND fpcamProcessedExp.cam_id IS NULL) OR
+    AND ((fpcamRun.state = 'new'    AND fpcamProcessedExp.fpcam_id IS NULL) OR
          (fpcamRun.state = 'update' AND fpcamProcessedExp.fault = 0 AND fpcamProcessedExp.quality = 0))
-    AND fpcamMask.label IS NULL
     AND (Label.active OR Label.active IS NULL)