Changeset 20608 for trunk/ippTools/share/chiptool_completely_processed_exp.sql

Timestamp:

Nov 9, 2008, 1:51:39 PM (18 years ago)

Author:

Paul Price

Message:

Change to run a subset of a camera seems to work, based on a simtest and a manual run through with one of two rawImfiles with ignored = 1. Merging pap_branch_20081109; no conflicts.

File:

• trunk/ippTools/share/chiptool_completely_processed_exp.sql (modified) (2 diffs)

trunk/ippTools/share/chiptool_completely_processed_exp.sql

@@ -13 +13 @@
     end_stage
 FROM
-    (SELECT 
+    (SELECT
         chipRun.*,
         rawImfile.class_id as rawimfile_class_id,
@@ -19 +19 @@
     FROM chipRun
     JOIN rawImfile
-        USING(exp_id)
+        ON chipRun.exp_id = rawImfile.exp_id
+        AND rawImfile.ignored = 0
     LEFT JOIN chipProcessedImfile
         ON chipRun.chip_id = chipProcessedImfile.chip_id