Changeset 27304 for trunk/ippTools/share/dqstatstool_definebyquery.sql

Timestamp:

Mar 16, 2010, 6:28:29 PM (16 years ago)

Author:

watersc1

Message:

IPP->OTIS image quality statistic publishing tool, with all the recent updates to make it work correctly and produce useful tables.

File:

• trunk/ippTools/share/dqstatstool_definebyquery.sql (modified) (2 diffs)

trunk/ippTools/share/dqstatstool_definebyquery.sql

@@ -1 +1 @@
 -- query to identify unique data to bundle
 
-SELECT exp_id,chip_id,cam_id,warp_id,invalid from rawExp 
+SELECT DISTINCT exp_id,chip_id,cam_id,warp_id,invalid from rawExp 
         JOIN chipRun USING(exp_id) 
         JOIN camRun USING(chip_id) 
@@ -7 +7 @@
         LEFT OUTER JOIN warpRun USING(fake_id)
         LEFT OUTER JOIN dqstatsContent USING (exp_id,chip_id,cam_id,warp_id)
-WHERE (invalid IS NULL OR invalid = 1)
+WHERE camRun.state = 'full'