[rhmessaging-commits] rhmessaging commits: r2808 - mgmt/trunk/cumin/python/cumin.

Author: eallen Date: 2008-11-15 17:34:09 -0500 (Sat, 15 Nov 2008) New Revision: 2808 Modified: mgmt/trunk/cumin/python/cumin/slot.strings Log: Added a join to job.custom_id so clicking on a slot vis can show the job. Modified: mgmt/trunk/cumin/python/cumin/slot.strings =================================================================== --- mgmt/trunk/cumin/python/cumin/slot.strings 2008-11-15 22:24:26 UTC (rev 2807) +++ mgmt/trunk/cumin/python/cumin/slot.strings 2008-11-15 22:34:09 UTC (rev 2808) @@ -5,10 +5,12 @@ s.machine, s.system, s.job_id, + j.id as jid, c.activity from slot as s left outer join slot_stats as c on c.id = s.stats_curr_id left outer join slot_stats as p on p.id = s.stats_prev_id +left outer join job as j on j.custom_id = s.job_id {sql_where} {sql_orderby} {sql_limit}