Changeset 33384 for trunk/ippTools/share/staticskytool_result.sql

Timestamp:

Feb 29, 2012, 7:39:44 AM (14 years ago)

Author:

bills

Message:

Fix bug in staticskytool -result. It was listing the filter in the
output which causes num_filters entries when a staticskyRun has
multiple filters. Change the sql to group by sky_id and list num_filters
instead. Also allow selection by tess_id and skycell_id

File:

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

trunk/ippTools/share/staticskytool_result.sql

@@ -1 @@
-SELECT DISTINCT
+SELECT
     staticskyResult.*,
     staticskyRun.state,
@@ -6 +6 @@
     stackRun.tess_id,
     stackRun.skycell_id,
-    stackRun.filter
+    count(stackRun.filter) AS num_filters
 FROM staticskyRun
 JOIN staticskyResult USING(sky_id)