Changeset 31604 for trunk/ippTools/share/laptool_definerun.sql

Timestamp:

Jun 6, 2011, 12:53:23 PM (15 years ago)

Author:

watersc1

Message:

update to correct exposure sharing behavior in LAP processing

File:

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

trunk/ippTools/share/laptool_definerun.sql

@@ -8 +8 @@
   ) AS want
   LEFT JOIN 
-  (SELECT exp_id,MAX(chip_id) AS chip_id
-     FROM lapExp 
+  (SELECT exp_id,MAX(chip_id) AS chip_id, chipRun.state
+     FROM lapExp JOIN chipRun USING(exp_id,chip_id) 
      where private IS FALSE 
      AND chip_id IS NOT NULL
-     AND active = TRUE ) AS have USING(exp_id)
+     AND 
+         (
+          -- (active = TRUE) OR 
+          (chipRun.state = 'full') OR
+          (chipRun.state = 'new')
+          -- when we can do updates, put that here.
+          )
+     GROUP BY exp_id
+) AS have USING(exp_id)