Changeset 26446 for trunk/ippTools/share/receivetool_toadvance.sql

Timestamp:

Dec 16, 2009, 3:57:48 PM (16 years ago)

Author:

bills

Message:

Add some stats to magicDSFile.
On the receive side, make it possible to disable a source

File:

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

trunk/ippTools/share/receivetool_toadvance.sql

@@ -10 +10 @@
     JOIN receiveFile USING(fileset_id)
     LEFT JOIN receiveResult USING(file_id)
-WHERE receiveFileset.state = 'new' 
+WHERE receiveSource.state = 'enabled'
+    AND receiveFileset.state = 'new' 
     AND receiveFileset.fault = 0
 GROUP BY fileset_id