Changeset 23783 for trunk/ippTools/share/disttool_definebyquery_camera.sql

Timestamp:

Apr 9, 2009, 3:20:44 PM (17 years ago)

Author:

bills

Message:

fix problems in definebyquery for camera stage

File:

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

trunk/ippTools/share/disttool_definebyquery_camera.sql

@@ -1 +1 @@
 SELECT
-    'cam' as stage,
+    'camera' as stage,
     camRun.cam_id as stage_id,
     rawExp.exp_name as run_tag,
@@ -16 +16 @@
     AND rcInterest.state = 'enabled'
     AND distRun.dist_id IS NULL      -- no existing distRun 
-    AND ((!distTarget.clean  AND camRun.state = 'full') OR (distTarget.clean AND camRun.state = 'cleaned'))
+    AND ((camRun.state = 'full') OR (distTarget.clean AND camRun.state = 'cleaned'))