Changeset 23381 for trunk/ippTools/share

Timestamp:

Mar 18, 2009, 10:10:16 AM (17 years ago)

Author:

bills

Message:

add chipRun.magicked

File:

• trunk/ippTools/share/chiptool_completely_processed_exp.sql (modified) (1 diff)

trunk/ippTools/share/chiptool_completely_processed_exp.sql

@@ -11 +11 @@
     dvodb,
     tess_id,
-    end_stage
+    end_stage,
+    all_files_magicked as magicked
 FROM
     (SELECT
         chipRun.*,
         rawImfile.class_id as rawimfile_class_id,
-        chipProcessedImfile.class_id
+        chipProcessedImfile.class_id,
+        SUM(!chipProcessedImfile.magicked) = 0 as all_files_magicked
     FROM chipRun
     JOIN rawImfile