Changeset 25913 for trunk/ippTools/share/flatcorr_chiprundone.sql

Timestamp:

Oct 21, 2009, 3:26:31 PM (17 years ago)

Author:

eugene

Message:

adding feature to control if analysis generates a correction image or not

File:

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

trunk/ippTools/share/flatcorr_chiprundone.sql

@@ -7 +7 @@
 JOIN chipRun
     USING(chip_id)
-LEFT JOIN camRun
-    ON chipRun.chip_id = camRun.chip_id
+LEFT JOIN flatcorrCamLink
+    using(corr_id, chip_id)
 WHERE
     flatcorrRun.state = 'new'
     AND flatcorrChipLink.include = 1
     AND chipRun.state = 'full'
-    AND camRun.cam_id is NULL
+    AND flatcorrCamLink.corr_id is NULL