Changeset 19610

Timestamp:

Sep 19, 2008, 4:02:47 AM (18 years ago)

Author:

eugene

Message:

working on allowing processing for verify

File:

• branches/eam_branch_20080918/ippTools/share/dettool_toresidimfile.sql (modified) (2 diffs)

branches/eam_branch_20080918/ippTools/share/dettool_toresidimfile.sql

@@ -55 +55 @@
     detRun.workdir,
     detRun.reduction,
-    rawImfile.exp_id,
-    rawImfile.class_id,
-    rawImfile.uri,
+    -- XXX convert these to detProcessedImfile matching this detRun 
+    detProcessedImfile.exp_id,
+    detProcessedImfile.class_id,
+    detProcessedImfile.uri,
     detNormalizedImfile.uri AS det_uri,
     detRun.ref_det_id,
@@ -74 +75 @@
 JOIN rawExp
     ON detInputExp.exp_id = rawExp.exp_id
-JOIN rawImfile
-    ON detInputExp.exp_id = rawImfile.exp_id
+JOIN detProcessedImfile
+    ON detProcessedImfile.exp_id = detInputExp.exp_id
+   AND detProcessedImfile.det_id = detRun.det_id
+   AND detProcessedImfile.iteration = detRun.iteration
 LEFT JOIN detResidImfile
     ON detRun.det_id = detResidImfile.det_id