Changeset 31407 for branches/czw_branch/20110406/ippTools/share/laptool_pendingexp.sql

Timestamp:

Apr 28, 2011, 6:41:17 PM (15 years ago)

Author:

watersc1

Message:

Majority of ippTools/SQL work should be complete now. Need to start queueing exposures, and testing the script

File:

• branches/czw_branch/20110406/ippTools/share/laptool_pendingexp.sql (modified) (1 diff)

branches/czw_branch/20110406/ippTools/share/laptool_pendingexp.sql

@@ -1 @@
-select lap_id, projection_cell, tess_id, registered, state, fault,
-       exp_id, chip_id, pair_id, private, pairwise, active, data_state,
+select lapRun.lap_id, lapRun.seq_id, lapRun.tess_id, lapRun.projection_cell, lapRun.filter, lapRun.state, lapRun.label,
+       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
   FROM lapRun JOIN lapExp USING(lap_id)
-  JOIN rawExp USING(exp_id)
-WHERE active IS TRUE AND fault = 0
+  JOIN rawExp USING(exp_id,filter)
+WHERE active IS TRUE AND lapRun.fault = 0
 -- lap_id restriction here.
 -- This probably needs to be sorted by dateobs.