Changeset 39802

Timestamp:

Nov 3, 2016, 3:37:23 PM (10 years ago)

Author:

watersc1

Message:

Update from trunk with update to pztool -pendingimfile SQL union to prioritize science over camera commanded exposures.

File:

• tags/ipp-20141024/ippTools/share/pztool_pendingimfile.sql (modified) (2 diffs, 1 prop)

tags/ipp-20141024/ippTools/share/pztool_pendingimfile.sql

@@ -20 +20 @@
         AND pzDownloadImfile.class IS NULL
         AND pzDownloadImfile.class_id IS NULL
-        AND summitImfile.exp_name NOT LIKE '%a'
+        AND summitImfile.exp_name NOT LIKE 'c%'
     ORDER BY dateobs) AS partA
 UNION
@@ -42 +42 @@
         AND pzDownloadImfile.class IS NULL
         AND pzDownloadImfile.class_id IS NULL
-        AND summitImfile.exp_name LIKE '%a'
+        AND summitImfile.exp_name LIKE 'c%'
     ORDER BY dateobs) AS partB
 ) as Foo