Changeset 36853 for trunk/ippTools/share/remotetool_definebyquery_cam.sql

Timestamp:

Jun 12, 2014, 5:24:29 PM (12 years ago)

Author:

watersc1

Message:

Corrections to sql to prevent double queuing

File:

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

trunk/ippTools/share/remotetool_definebyquery_cam.sql

@@ -9 +9 @@
 WHERE
 camRun.state = 'new' AND
-remoteRun.stage = 'camera' AND
-remote_id IS NULL
+(remoteRun.stage = 'camera' OR remoteRun.state IS NULL) AND
+remoteComponent.remote_id IS NULL