Changeset 18688 for trunk/ippTools/share/faketool_find_pendingexp.sql

Timestamp:

Jul 23, 2008, 3:17:52 PM (18 years ago)

Author:

Paul Price

Message:

Exposure level requires that fakeProcessedImfile is populated, so
fakeProcessedImfile.fake_id IS *NOT* NULL.

File:

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

trunk/ippTools/share/faketool_find_pendingexp.sql

@@ -1 +1 @@
 -- this query is used by both camtool -pendingexp & camtool -addprocessedexp it
 -- does a little more work then is necessary for -addprocessed but it seems
--- "cleaner" to use the same query for both cases 
+-- "cleaner" to use the same query for both cases
 SELECT * FROM
     (SELECT
@@ -29 +29 @@
         AND chipRun.state = 'full'
         AND fakeMask.label IS NULL
-        AND fakeProcessedImfile.fake_id IS NULL
+        AND fakeProcessedImfile.fake_id IS NOT NULL
     GROUP BY
         fakeRun.fake_id