Changeset 30387 for trunk/ippTools/share/disttool_pending_chip.sql

Timestamp:

Jan 27, 2011, 9:42:21 AM (15 years ago)

Author:

bills

Message:

order pending components by priority

File:

• trunk/ippTools/share/disttool_pending_chip.sql (modified) (3 diffs)

trunk/ippTools/share/disttool_pending_chip.sql

@@ -15 +15 @@
     chipProcessedImfile.quality,
     distRun.no_magic,
-    chipProcessedImfile.magicked
+    chipProcessedImfile.magicked,
+    IFNULL(Label.priority, 10000) AS priority
 FROM distRun
 JOIN distTarget USING(target_id, stage, clean)
@@ -24 +25 @@
     ON distRun.dist_id = distComponent.dist_id 
     AND chipProcessedImfile.class_id = distComponent.component
+LEFT JOIN Label
+    ON distRun.label = Label.label
 WHERE
     distRun.state = 'new'
@@ -30 +33 @@
     AND ((chipRun.magicked > 0) OR distRun.no_magic)
     AND (chipRun.state = 'full' OR (distRun.clean AND chipRun.state = 'cleaned'))
+    AND (Label.active OR Label.active IS NULL)