Changeset 25913 for trunk/ippTools/share/flatcorr_camerarundone.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_camerarundone.sql (modified) (1 diff)

trunk/ippTools/share/flatcorr_camerarundone.sql

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