Changeset 32422 for trunk/ippTools/share/laptool_pendingexp.sql

Timestamp:

Sep 21, 2011, 11:11:16 AM (15 years ago)

Author:

watersc1

Message:

Update to LAP code.

File:

• trunk/ippTools/share/laptool_pendingexp.sql (modified) (1 diff)

trunk/ippTools/share/laptool_pendingexp.sql

@@ -3 +3 @@
        lapRun.dist_group, lapRun.registered, lapRun.fault, lapRun.quick_sass_id, lapRun.final_sass_id,
        exp_id, chip_id, pair_id, private, pairwise, active, lapExp.data_state,
-       dateobs, object, comment
+       dateobs, object, comment,
+       chipRun.state AS chip_state
   FROM lapRun JOIN lapExp USING(lap_id)
   JOIN rawExp USING(exp_id,filter)
+  LEFT JOIN chipRun USING(exp_id,chip_id)
 WHERE active IS TRUE AND lapRun.fault = 0
 -- lap_id restriction here.