Changeset 35313

Timestamp:

Mar 15, 2013, 1:29:22 PM (13 years ago)

Author:

bills

Message:

show status of requests in state 'preview' too

File:

• tags/ipp-20130307/pstamp/scripts/psstatus (modified) (3 diffs)

tags/ipp-20130307/pstamp/scripts/psstatus

@@ -81 +81 @@
 LEFT JOIN Label USING(label)
     WHERE pstampRequest.state = 'run' or pstampRequest.state ='new' 
+        OR pstampRequest.state = 'preview'
    --     OR pstampRequest.state = 'run.wait'
 ) as unfinishedReq
@@ -89 +90 @@
 FROM pstampRequest JOIN pstampJob USING(req_id)
     WHERE (pstampRequest.state = 'run' or pstampRequest.state = 'new' 
-        OR pstampRequest.state = 'run.wait')
+        OR pstampRequest.state = 'run.wait'
+        OR pstampRequest.state = 'preview')
     GROUP BY req_id
 ) as rowCounts
@@ -101 +103 @@
     JOIN pstampDependent USING(dep_id) 
     WHERE (pstampRequest.state = 'run' or pstampRequest.state = 'new' 
+            OR pstampRequest.state = 'preview'
             OR pstampRequest.state = 'run.wait')
         AND dep_id > 0