Changeset 31775

Timestamp:

Jun 29, 2011, 10:05:56 AM (15 years ago)

Author:

Serge CHASTEL

Message:

LAP stacks

File:

• branches/sc_branches/ippMonitorLap/def/lapStacks.d (modified) (2 diffs)

branches/sc_branches/ippMonitorLap/def/lapStacks.d

@@ -1 @@
-TABLE lapRun JOIN stackAssociationMap AS stackAssociationMap1 ON stackAssociationMap1.sass_id=lapRun.quick_sass_id JOIN stackRun AS stackRun1 ON stackRun1.stack_id=stackAssociationMap1.stack_id JOIN stackSumSkyfile AS stackSumSkyfile1 ON stackSumSkyfile1.stack_id=stackAssociationMap1.stack_id
+TABLE lapRun JOIN stackAssociationMap AS stackAssociationMap1 ON stackAssociationMap1.sass_id=lapRun.quick_sass_id JOIN stackRun AS stackRun1 ON stackRun1.stack_id=stackAssociationMap1.stack_id JOIN stackSumSkyfile AS stackSumSkyfile1 ON stackSumSkyfile1.stack_id=stackAssociationMap1.stack_id JOIN stackAssociationMap AS stackAssociationMap2 ON stackAssociationMap2.sass_id=lapRun.quick_sass_id JOIN stackRun AS stackRun2 ON stackRun2.stack_id=stackAssociationMap2.stack_id
 TITLE LAP Stacks
 FILE  lapStacks.php
@@ -30 +30 @@
 # FIELD stackRun.skycell_id,    15, %s,  Skycell ID
 FIELD lapRun.quick_sass_id,     6, %d,   Quick SASS ID
-FIELD stackRun1.stack_id,       6, %d,   Quick Stack ID
-FIELD stackRun1.data_group,     15, %s,  Quick Data Group
+FIELD stackRun1.stack_id AS quick_stack_id,     6, %d,   Quick Stack ID
+FIELD stackRun1.data_group AS quick_data_group, 15, %s,  Quick Data Group
 FIELD stackRun1.state AS quick_state,   6, %s,     Quick State
 FIELD stackSumSkyfile1.fault AS quick_fault,    6, %d,     Quick Fault
 FIELD stackSumSkyfile1.quality AS quick_quality,        6, %d,     Quick Quality    
 FIELD lapRun.final_sass_id,     6, %d,   Final SASS ID      
-# FIELD lapRun.final_data_group,        15, %s,    Final Data Group 
+FIELD stackRun2.data_group AS final_data_group, 15, %s,    Final Data Group 
 # FIELD lapRun.final_stack_id,  6, %d,   Final Stack ID     
 # FIELD lapRun.final_state,     6, %s,     Final State