Changeset 31396 for branches/czw_branch/20110406/ippTools/share/laptool_pendingrun.sql

Timestamp:

Apr 27, 2011, 7:33:50 PM (15 years ago)

Author:

watersc1

Message:

pre-build test checkin of LAP code

File:

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

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

@@ -1 @@
-select lap_id, projection_cell, tess_id, registered, state, fault,
-       exp_id, chip_id, pair_id, private, pairwise, active, data_state,
-       dateobs, object, comment
-  FROM lapRun JOIN lapExp USING(lap_id)
-  JOIN rawExp USING(exp_id)
-WHERE active IS TRUE AND fault = 0
--- lap_id restriction here.
--- This probably needs to be sorted by dateobs.
+SELECT * from lapRun