Changeset 41201 for trunk/ippMonitor/def/fullforceInputSkyfile.d

Timestamp:

Dec 12, 2019, 12:41:54 PM (7 years ago)

Author:

tdeboer

Message:

small change to fullforce

File:

• trunk/ippMonitor/def/fullforceInputSkyfile.d (modified) (1 diff)

trunk/ippMonitor/def/fullforceInputSkyfile.d

@@ -1 @@
-TABLE fullForceInput, fullForceRun, warpRun
+TABLE fullForceInput JOIN fullForceRun USING (ff_id) JOIN warpRun USING (warp_id)
 TITLE Full Force Input Exposures 
 FILE  fullforceInputSkyfile.php
 MENU  ipp.ffs.dat
 
-WHERE fullForceRun.ff_id = fullForceInput.ff_id AND fullForceInput.warp_id = warpRun.warp_id
-
 #        field                          size  format  name           show     link to         extras
 FIELD fullForceRun.ff_id,          5, %s,     FF ID
-FIELD fullForceRun.label,           7, %s,     Label
-FIELD fullForceRun.state,           7, %s,     State
+FIELD fullForceRun.label,           7, %s,     Label
+FIELD fullForceRun.state,           7, %s,     State
 FIELD warpRun.warp_id,            5, %s,     Warp ID
 FIELD warpRun.tess_id,             5, %s,     Tess ID
 FIELD warpRun.label,               5, %s,     warp Label
-FIELD fullForceRun.data_group,      7, %s,     data grp
-FIELD fullForceRun.dist_group,      7, %s,     dist grp
-
+FIELD fullForceRun.data_group,      7, %s,     data grp
+FIELD fullForceRun.dist_group,      7, %s,     dist grp