Changeset 25835 for trunk/ippTools/share/disttool_pending_raw.sql

Timestamp:

Oct 14, 2009, 11:06:18 AM (17 years ago)

Author:

bills

Message:

Add data_group, dist_group, and note to the pipeline. These new columns will be used
for some of the tasks that label was used previously.

File:

• trunk/ippTools/share/disttool_pending_raw.sql (modified) (4 diffs)

trunk/ippTools/share/disttool_pending_raw.sql

@@ -2 +2 @@
     distRun.dist_id,
     distRun.label,
+    distTarget.dist_group,
     stage,
     stage_id,
@@ -16 +17 @@
     rawImfile.magicked
 FROM distRun
+JOIN distTarget USING(target_id, stage)
 JOIN rawExp ON rawExp.exp_id = stage_id
 JOIN rawImfile USING(exp_id)
@@ -35 +37 @@
     distRun.dist_id,
     distRun.label,
+    distTarget.dist_group,
     stage,
     stage_id,
@@ -49 +52 @@
     rawExp.magicked
 FROM distRun
+JOIN distTarget USING(target_id, stage)
 JOIN rawExp ON exp_id = stage_id
 LEFT JOIN distComponent