Changeset 24787

Timestamp:

Jul 14, 2009, 11:26:57 AM (17 years ago)

Author:

bills

Message:

receiveFilesets are only pending when their state is still 'reg'
and they are not faulted

File:

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

trunk/ippTools/share/receivetool_pendingfileset.sql

@@ -1 +1 @@
 SELECT *
 FROM receiveFileset
-JOIN receiveSource USING(source_id)
-LEFT JOIN receiveFile USING(fileset_id)
-WHERE receiveFile.fileset_id IS NULL
+WHERE state = 'reg'
+    AND fault = 0