Changeset 19558 for trunk/ippTools/share/faketool_pendingimfile.sql

Timestamp:

Sep 15, 2008, 2:21:00 PM (18 years ago)

Author:

bills

Message:

changes to support cleanup, purge, and update processing

File:

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

trunk/ippTools/share/faketool_pendingimfile.sql

@@ -41 +41 @@
         ON fakeRun.label = fakeMask.label
     WHERE
-        fakeProcessedImfile.fake_id IS NULL
-        AND fakeProcessedImfile.class_id IS NULL
+        ((fakeRun.state = 'new'
+            AND fakeProcessedImfile.fake_id IS NULL
+            AND fakeProcessedImfile.class_id IS NULL
+        ) 
+        OR (fakeRun.state = 'update'
+            AND fakeProcessedImfile.data_state = 'cleaned')
+        )
         AND fakeMask.label IS NULL
     ) as fakePendingImfile