Changeset 28339 for trunk/ippTools/share/camtool_pendingexp.sql

Timestamp:

Jun 15, 2010, 1:57:07 PM (16 years ago)

Author:

bills

Message:

implement ordering by Label.priority for camtool -processedexp
Needed to stop sharing the sql to implement this

File:

• trunk/ippTools/share/camtool_pendingexp.sql (moved) (moved from trunk/ippTools/share/camtool_find_pendingexp.sql ) (3 diffs)

trunk/ippTools/share/camtool_pendingexp.sql

@@ -1 @@
--- this query is used by both camtool -pendingexp & camtool -addprocessedexp it
--- does a little more work then is necessary for -addprocessed but it seems
--- "cleaner" to use the same query for both cases 
 SELECT
     camRun.*,
@@ -11 +8 @@
     rawExp.filelevel,
     chipRun.magicked AS chip_magicked,
-    camProcessedExp.path_base
+    camProcessedExp.path_base,
+    IFNULL(Label.priority, 10000) AS priority
 FROM camRun
 JOIN chipRun
@@ -21 +19 @@
 LEFT JOIN camMask
     ON camRun.label = camMask.label
+LEFT JOIN Label
+    ON camRun.label = Label.label
 WHERE
     chipRun.state = 'full'
     AND ((camRun.state = 'new' AND camProcessedExp.cam_id IS NULL) OR camRun.state = 'update')
     AND camMask.label IS NULL
+    AND (Label.active OR Label.active IS NULL)