Changeset 38563 for trunk/ippTools/share/staticskytool_pendingskycalrun.sql

Timestamp:

Jul 2, 2015, 9:40:59 AM (11 years ago)

Author:

bills

Message:

support for skycal updates add staticskytool_revert_update.sql

File:

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

trunk/ippTools/share/staticskytool_pendingskycalrun.sql

@@ -19 +19 @@
 LEFT JOIN skycalResult USING(skycal_id)
 WHERE
-   (skycalRun.state = 'new' AND skycalResult.skycal_id IS NULL)
+   ((skycalRun.state = 'new' AND skycalResult.skycal_id IS NULL)
+    OR (skycalRun.state ='update' and staticskyRun.state ='full' and skycalResult.fault = 0))