Changeset 31741

Timestamp:

Jun 28, 2011, 4:40:06 PM (15 years ago)

Author:

Serge CHASTEL

Message:

Updating with CZW req

File:

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

branches/sc_branches/ippMonitorLap/def/lapExposures.d

@@ -1 @@
-TABLE lapRun JOIN lapExp USING(lap_id) JOIN rawExp USING(exp_id,filter) JOIN chipRun USING(chip_id)
-#JOIN chipRun USING(lapExp.chip_id) 
-#JOIN chipRun AS pairRun USING(lapExp.pair_id)
+TABLE lapRun JOIN lapExp USING(lap_id) JOIN rawExp USING(exp_id,filter) JOIN chipRun USING(chip_id) JOIN chipRun AS pairRun WHERE pairRun.chip_id=lapExp.pair_id
 TITLE LAP Exposures
 FILE  lapExposures.php
@@ -16 +14 @@
 FIELD lapExp.exp_id,          6, %d,     Exp ID,        value, rawImfile.php, ARG1
 FIELD lapExp.chip_id,         6, %d,     Chip ID,       value, chipStageExp.php, ARG2
-FIELD chipRun.state,          6, %s,     State (chipRun)
+FIELD chipRun.state,          6, %s,     State (chip_id)
 FIELD lapExp.pair_id,         6, %d,     Pair ID,       value, chipStageExp.php, ARG3
+FIELD pairRun.state,          6, %s,     State (pair_id)
 FIELD lapRun.tess_id,         8, %s,     tess_id
 FIELD lapRun.projection_cell, 10, %s,    ProjCell