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

Timestamp:

Jan 12, 2015, 12:53:36 PM (11 years ago)

Author:

eugene

Message:

merging changes from ipp-pv3-20140717 (via branches/eam_branches/ipp-pv3-20140717-merge)

File:

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

trunk/ippTools/share/remotetool_definebyquery_cam.sql

@@ -11 +11 @@
 LEFT JOIN
 
-(SELECT remote_id,remoteRun.stage,remoteRun.label,remoteComponent.stage_id,remoteRun.state 
-   FROM remoteRun 
+(SELECT remote_id,remoteRun.stage,remoteRun.label,remoteComponent.stage_id,remoteRun.state
+   FROM remoteRun
    JOIN remoteComponent USING (remote_id)
 WHERE
-remoteRun.stage = 'camera'
+remoteRun.stage = 'camera' and remoteComponent.state != 'retry'
 -- where hook %s
 ) AS R