Changeset 23581 for branches/pap/ippTools/share/flatcorr_pending.sql

Timestamp:

Mar 27, 2009, 5:12:32 PM (17 years ago)

Author:

Paul Price

Message:

Set some bounds on data-quality for various operations. QUALITY isn't a boolean value, but integer.

File:

• branches/pap/ippTools/share/flatcorr_pending.sql (modified) (2 diffs)

branches/pap/ippTools/share/flatcorr_pending.sql

@@ -1 @@
-SELECT 
+SELECT
     *
 FROM
@@ -21 +21 @@
 HAVING
     COUNT(rawImfile.class_id) = COUNT(chipProcessedImfile.class_id)
-    AND SUM(chipProcessedImfile.fault) = 0
+    AND SUM(chipProcessedImfile.fault > 0) = 0