Changeset 30483

Timestamp:

Feb 3, 2011, 10:28:03 AM (15 years ago)

Author:

bills

Message:

add priority and timestamp.

File:

• trunk/pstamp/scripts/psstatus (modified) (3 diffs)

trunk/pstamp/scripts/psstatus

@@ -51 +51 @@
     label,
     reqType,
+    priority,
     state,
     fault,
@@ -59 +60 @@
     IFNULL(faultedJobs, 0) AS 'Faulted Jobs',
     IFNULL(depcount, 0) AS 'Image updates'
-    -- timestamp AS 'last state change (UTC)'
+    , timestamp AS 'last state change (UTC)'
 FROM (
     SELECT
@@ -68 +69 @@
         pstampRequest.state,
         pstampRequest.fault,
-        timestamp
-FROM pstampRequest
+        timestamp,
+        priority
+FROM pstampRequest
+JOIN Label USING(label)
     WHERE pstampRequest.state = 'run' or pstampRequest.state ='new' 
-        OR pstampRequest.state = 'run.wait'
+   --     OR pstampRequest.state = 'run.wait'
 ) as unfinishedReq
 LEFT JOIN (