Changeset 27856 for trunk/ippTools/share/pstamptool_completedreq.sql

Timestamp:

May 4, 2010, 10:50:29 AM (16 years ago)

Author:

bills

Message:

Add table Label which through priority column may be used to order
items pending for processing.
Implement usage of this table in the pstamptool pending modes and
chiptool -pendingimfile.
Various other postage stamp changes including adding pstampDependent.outdir

File:

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

trunk/ippTools/share/pstamptool_completedreq.sql

@@ -1 @@
-SELECT * 
+SELECT pstampRequest.* ,
+    IFNULL(labels.priority, 0) AS priority
 FROM pstampRequest 
+    LEFT JOIN labels USING(label) 
 WHERE state = 'run'
     AND (