Changeset 25870 for branches/eam_branches/20090820/ippTools/share/disttool_pending_chip.sql

Timestamp:

Oct 18, 2009, 10:23:28 AM (17 years ago)

Author:

eugene

Message:

updated vysos branch from trunk

Location:

branches/eam_branches/20090820

Files:

• . (modified) (1 prop)
• ippTools/share/disttool_pending_chip.sql (modified) (2 diffs)

branches/eam_branches/20090820/ippTools/share/disttool_pending_chip.sql

@@ -2 +2 @@
     distRun.dist_id,
     distRun.label,
+    distTarget.dist_group,
     stage,
     stage_id,
     chipProcessedImfile.class_id AS component,
-    clean,
+    distRun.clean,
     rawExp.camera,
     CONCAT_WS('.', outroot, CONVERT(distRun.dist_id, CHAR)) as outdir,
@@ -16 +17 @@
     chipProcessedImfile.magicked
 FROM distRun
+JOIN distTarget USING(target_id, stage, clean)
 JOIN chipRun ON chipRun.chip_id = distRun.stage_id
 JOIN rawExp using(exp_id)