Changeset 23717 for trunk/ippTools/share/disttool_toadvance.sql

Timestamp:

Apr 6, 2009, 3:15:05 PM (17 years ago)

Author:

bills

Message:

poll modes need to support query by label

File:

• trunk/ippTools/share/disttool_toadvance.sql (modified) (6 diffs)

trunk/ippTools/share/disttool_toadvance.sql

@@ -3 +3 @@
     stage,
     stage_id,
-    outroot
+    outroot,
+    label
 FROM
     (
@@ -11 +12 @@
     stage,
     stage_id,
-    outroot
+    outroot,
+    label
     FROM distRun
     JOIN rawImfile ON stage_id = rawImfile.exp_id
@@ -33 +35 @@
     stage,
     stage_id,
-    outroot
+    outroot,
+    label
     FROM distRun
     JOIN chipProcessedImfile ON stage_id = chipProcessedImfile.chip_id
@@ -55 +58 @@
     stage,
     stage_id,
-    outroot
+    outroot,
+    label
     FROM distRun
     JOIN warpSkyfile on stage_id = warp_id
@@ -79 +83 @@
     stage,
     stage_id,
-    outroot
+    outroot,
+    label
     FROM distRun
     JOIN diffSkyfile
@@ -103 +108 @@
     stage,
     stage_id,
-    outroot
+    outroot,
+    label
     FROM distRun
     JOIN stackSumSkyfile on stage_id = stack_id