Changeset 29407 for trunk/ippTools/share/addtool_find_cam_id.sql

Timestamp:

Oct 14, 2010, 11:31:20 AM (16 years ago)

Author:

heather

Message:

now checks for quality > 0 to prevent camRuns with no smf files from being queued.

File:

• trunk/ippTools/share/addtool_find_cam_id.sql (modified) (3 diffs)

trunk/ippTools/share/addtool_find_cam_id.sql

@@ -2 +2 @@
     camRun.*
 FROM camRun
+JOIN camProcessedExp
+    USING(cam_id)
 JOIN chipRun
     USING(chip_id)
@@ -10 +12 @@
            FROM addRun
            JOIN camRun USING(cam_id)
-           JOIN chipRun USING(chip_id)
+           JOIN chipRun USING(chip_id)
           ) as foo
      ON exp_id = added_exp_id
@@ -17 +19 @@
 WHERE
     camRun.state = 'full'
+    AND camProcessedExp.quality = 0
     AND added_exp_id IS NULL
     -- addtool adds checks on exposure being added to the dvodb previously