Changeset 14023 for trunk/ippTools/share/dettool_find_completed_runs.sql

Timestamp:

Jul 5, 2007, 3:16:08 PM (19 years ago)

Author:

jhoblitt

Message:

rename exp_id -> exp_name
rename exp_tag -> exp_id
add add rawExp.exp_tag for use as an external name only

File:

• trunk/ippTools/share/dettool_find_completed_runs.sql (modified) (3 diffs)

trunk/ippTools/share/dettool_find_completed_runs.sql

@@ -6 +6 @@
         detRun.det_id,
         detRun.iteration,
-        detInputExp.exp_tag
+        detInputExp.exp_id
     FROM detRun
         LEFT JOIN detInputExp
@@ -12 +12 @@
         AND detRun.iteration = detInputExp.iteration
     LEFT JOIN rawExp
-        ON detInputExp.exp_tag = rawExp.exp_tag
+        ON detInputExp.exp_id = rawExp.exp_id
     LEFT JOIN detResidExp
         ON detRun.det_id = detResidExp.det_id
         AND detRun.iteration = detResidExp.iteration
-        AND detInputExp.exp_tag = detResidExp.exp_tag
+        AND detInputExp.exp_id = detResidExp.exp_id
    WHERE
         detRun.state = 'run'
@@ -23 +23 @@
         detRun.iteration
     HAVING
-        COUNT(detResidExp.exp_tag) = COUNT(detInputExp.exp_tag)
+        COUNT(detResidExp.exp_id) = COUNT(detInputExp.exp_id)
     ) AS residdetrun