Changeset 24951 for branches/czw_branch/cleanup/ippTools/share/receivetool_pendingfileset.sql

Timestamp:

Jul 30, 2009, 5:20:29 PM (17 years ago)

Author:

watersc1

Message:

Finished up my edits to the detrend cleanup, and some changes to my
copy of burntool and the pslib astrometry. Detrend cleanup has not
been tested yet. That's up next.

Location:

branches/czw_branch/cleanup

Files:

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

branches/czw_branch/cleanup/ippTools/share/receivetool_pendingfileset.sql

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