Changeset 30697
- Timestamp:
- Feb 19, 2011, 4:11:09 AM (15 years ago)
- File:
-
- 1 edited
-
tags/ipp-20110218/pstamp/scripts/psstatus (modified) (2 diffs, 1 prop)
Legend:
- Unmodified
- Added
- Removed
-
tags/ipp-20110218/pstamp/scripts/psstatus
-
Property svn:mergeinfo
set to (toggle deleted branches)
/branches/czw_branch/20101203/pstamp/scripts/psstatus merged eligible /branches/eam_branches/ipp-20101205/pstamp/scripts/psstatus merged eligible /trunk/pstamp/scripts/psstatus merged eligible /branches/eam_branches/ipp-20101103/pstamp/scripts/psstatus 29657-29920
r30517 r30697 44 44 45 45 my $totals_query = " 46 SELECT label, count(job_id) AS 'Unfinished Jobs', priority 46 SELECT label, 47 count(job_id) AS 'Unfinished Jobs', 48 IFNULL(priority,10000) as priority 47 49 FROM pstampRequest join pstampJob USING(req_id) 48 JOIN Label USING(label)50 LEFT JOIN Label USING(label) 49 51 WHERE pstampJob.state ='run' and pstampRequest.state ='run' 50 52 GROUP by label"; … … 75 77 pstampRequest.fault, 76 78 timestamp, 77 priority78 FROM pstampRequest 79 JOIN Label USING(label)79 IFNULL(priority,10000) AS priority 80 FROM pstampRequest 81 LEFT JOIN Label USING(label) 80 82 WHERE pstampRequest.state = 'run' or pstampRequest.state ='new' 81 83 -- OR pstampRequest.state = 'run.wait' -
Property svn:mergeinfo
set to (toggle deleted branches)
Note:
See TracChangeset
for help on using the changeset viewer.
