Changeset 36431 for trunk/ippTools/share/chiptool_pendingcleanuprun.sql

Timestamp:

Jan 8, 2014, 12:21:52 PM (12 years ago)

Author:

bills

Message:

order results of chiptool -pendingcleanuprun by Label.priority.

File:

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

trunk/ippTools/share/chiptool_pendingcleanuprun.sql

@@ -4 +4 @@
     rawExp.exp_tag,
     chipRun.state,
-    chipRun.workdir
+    chipRun.workdir,
+    chipRun.label,
+    IFNULL(Label.priority, 10000) AS priority
 FROM chipRun
 JOIN rawExp 
 USING (exp_id)
+LEFT JOIN Label ON chipRun.label = Label.label
 WHERE
     (chipRun.state = 'goto_cleaned' OR chipRun.state = 'goto_scrubbed' OR chipRun.state = 'goto_purged')