Changeset 25816 for trunk/ippTools/share/addtool_find_pendingexp.sql

Timestamp:

Oct 8, 2009, 5:09:53 PM (17 years ago)

Author:

eugene

Message:

updates to the addstar stage; modify flatcorr to interact correctly with the addstar stage

File:

• trunk/ippTools/share/addtool_find_pendingexp.sql (modified) (3 diffs)

trunk/ippTools/share/addtool_find_pendingexp.sql

@@ -1 +1 @@
 SELECT
     addRun.*,
+    camProcessedExp.path_base as camroot,
     rawExp.exp_tag,
     rawExp.exp_id,
@@ -9 +10 @@
 FROM addRun
 JOIN camRun
+    USING(cam_id)
+JOIN camProcessedExp
     USING(cam_id)
 JOIN chipRun
@@ -21 +24 @@
     camRun.state = 'full'
     AND ((addRun.state = 'new' AND addProcessedExp.add_id IS NULL) OR addRun.state = 'update')
+    AND addRun.dvodb IS NOT NULL
+    AND addRun.workdir IS NOT NULL
     AND addMask.label IS NULL