Changeset 41211 for branches/ccl_branches/ipponly-20191108/ippTools/share/addtool_find_pendingexp_cam.sql

Timestamp:

Dec 22, 2019, 4:11:49 PM (7 years ago)

Author:

cclin33

Message:

update addstar for multiple hosts

File:

• branches/ccl_branches/ipponly-20191108/ippTools/share/addtool_find_pendingexp_cam.sql (modified) (2 diffs)

branches/ccl_branches/ipponly-20191108/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'