Changeset 41213 for trunk/ippTools/share/addtool_find_pendingexp_cam.sql

Timestamp:

Dec 24, 2019, 2:57:20 AM (7 years ago)

Author:

cclin33

Message:

update for addstar tasks

File:

• trunk/ippTools/share/addtool_find_pendingexp_cam.sql (modified) (2 diffs)

trunk/ippTools/share/addtool_find_pendingexp_cam.sql

@@ -7 +7 @@
     rawExp.camera,
     rawExp.telescope,
-    rawExp.filelevel
+    rawExp.filelevel,
+    minidvodbRun.minidvodb_host as dvodbhost
 FROM addRun
+JOIN minidvodbRun
+    on addRun.minidvodb_group = minidvodbRun.minidvodb_group
 JOIN camRun
     on cam_id = stage_id
@@ -28 +31 @@
     AND addRun.workdir IS NOT NULL
     AND addMask.label IS NULL
+    AND minidvodbRun.state = 'active'