Changeset 42596 for branches/eam_branches/ipp-20230313/ippTools/share/xcskytool_todo.sql

Timestamp:

Jan 19, 2024, 8:12:15 AM (2 years ago)

Author:

eugene

Message:

working on xcfftool

File:

• branches/eam_branches/ipp-20230313/ippTools/share/xcskytool_todo.sql (modified) (2 diffs)

branches/eam_branches/ipp-20230313/ippTools/share/xcskytool_todo.sql

@@ +1 @@
+ -- we implicitly assume that all xcstackRuns used for a xcskyRun have the same tess_id and skycell_id 
 SELECT
     xcskyRun.xcsky_id,
@@ -5 +6 @@
     xcskyRun.label,
     xcskyRun.state,
-    MIN(xcstackRun.tess_id) as tess_id, -- we implicitly assume that all xcstackRuns used for a xcskyRun have the same tess_id
-    MIN(xcstackRun.skycell_id) as skycell_id, -- and skycell_id 
+    MIN(xcstackRun.tess_id) as tess_id,
+    MIN(xcstackRun.skycell_id) as skycell_id,
     TRUNCATE(MIN(skycell.radeg)/15., 4) as rahours,
     MIN(skycell.radeg) as radeg,