Changeset 29358 for trunk/ippTools/share/magicdstool_todestreak_camera.sql

Timestamp:

Oct 8, 2010, 11:15:35 AM (16 years ago)

Author:

bills

Message:

Implement ordering of pending components by priority

File:

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

trunk/ippTools/share/magicdstool_todestreak_camera.sql

@@ -19 +19 @@
     recoveryroot,
     re_place,
-    remove
+    remove,
+    IFNULL(Label.priority, 10000) AS priority
 FROM magicDSRun
 JOIN magicMask USING (magic_id)
@@ -29 +30 @@
 LEFT JOIN magicDSFile
     ON magicDSRun.magic_ds_id = magicDSFile.magic_ds_id
+LEFT JOIN Label ON magicDSRun.label = Label.label
 WHERE
     magicDSRun.state = 'new'
@@ -38 +40 @@
     AND camProcessedExp.quality = 0
     AND magicDSFile.component IS NULL
+    AND (Label.active OR Label.active IS NULL)