Changeset 31776

Timestamp:

Jun 29, 2011, 10:08:07 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 JOIN stackAssociationMap AS stackAssociationMap2 ON stackAssociationMap2.sass_id=lapRun.quick_sass_id JOIN stackRun AS stackRun2 ON stackRun2.stack_id=stackAssociationMap2.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 JOIN stackSumSkyfile AS stackSumSkyfile2 ON stackSumSkyfile2.stack_id=stackAssociationMap2.stack_id 
 TITLE LAP Stacks
 FILE  lapStacks.php
@@ -36 +36 @@
 FIELD stackSumSkyfile1.quality AS quick_quality,        6, %d,     Quick Quality    
 FIELD lapRun.final_sass_id,     6, %d,   Final SASS ID      
+FIELD stackRun2.stack_id AS final_stack_id,     6, %d,   Final Stack ID     
 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      
-# FIELD lapRun.final_fault,     6, %d,     Final Fault      
-# FIELD lapRun.final_quality    6, %d,     Final Quality    
+FIELD stackRun2.state AS final_state,   6, %s,     Final State      
+FIELD stackSumSkyfile2.fault AS final_fault,    6, %d,     Final Fault      
+FIELD stackSumSkyfile2.quality AS final_quality 6, %d,     Final Quality    
 
 MODE summary