Changeset 39801 for trunk/ippTools/share/pztool_pendingimfile.sql

Timestamp:

Nov 3, 2016, 3:18:18 PM (10 years ago)

Author:

watersc1

Message:

Update to prioritize not c% exp names over c% exp names.

File:

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

trunk/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