Changeset 26956 for trunk/ippTools/share/pubtool_definerun.sql

Timestamp:

Feb 15, 2010, 3:49:50 PM (16 years ago)

Author:

eugene

Message:

update pubtool -definerun to accept multiple labels

File:

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

trunk/ippTools/share/pubtool_definerun.sql

@@ -2 +2 @@
 SELECT
     client_id,
-    stage_id
+    stage_id,
+    src_label
 FROM (
     -- Get diffs to publish
     SELECT
         client_id,
-        diff_id AS stage_id
+        diff_id AS stage_id,
+        label AS src_label
     FROM publishClient
     JOIN diffRun
@@ -18 +20 @@
     SELECT
         client_id,
-        cam_id AS stage_id
+        cam_id AS stage_id,
+        label AS src_label
     FROM publishClient
     JOIN camRun