Changeset 20397 for trunk/ippTools/share/flatcorr_pendingprocess.sql

Timestamp:

Oct 25, 2008, 9:12:41 AM (18 years ago)

Author:

eugene

Message:

adding include fields to flatcorrChipLink and flatcorrCamLink

File:

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

trunk/ippTools/share/flatcorr_pendingprocess.sql

@@ -20 +20 @@
    JOIN flatcorrChipLink
      ON flatcorrChipLink.corr_id = flatcorrRun.corr_id
+  WHERE flatcorrChipLink.include = 1
    GROUP BY
      flatcorrChipLink.corr_id) AS t1
@@ -30 +31 @@
        ON flatcorrCamLink.cam_id = camRun.cam_id
    WHERE camRun.state = 'full'
+     AND flatcorrCamLink.include = 1
    GROUP BY
        flatcorrCamLink.corr_id) AS t2