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

Author: eallen Date: 2010-01-27 10:52:45 -0500 (Wed, 27 Jan 2010) New Revision: 3824 Modified: mgmt/trunk/cumin/python/cumin/usergrid/model.strings Log: Change SQL to reflect 'activity' moving from stats to slot table. Modified: mgmt/trunk/cumin/python/cumin/usergrid/model.strings =================================================================== --- mgmt/trunk/cumin/python/cumin/usergrid/model.strings 2010-01-27 15:13:55 UTC (rev 3823) +++ mgmt/trunk/cumin/python/cumin/usergrid/model.strings 2010-01-27 15:52:45 UTC (rev 3824) @@ -15,9 +15,8 @@ [LoadUserSlotStats.sql] select count(*) as total, - count(case c.activity when 'Busy' then 1 end) as busy, - count(case c.activity when 'Idle' then 1 end) as idle, - count(case c.activity when 'Suspended' then 1 end) as suspended + count(case s.activity when 'Busy' then 1 end) as busy, + count(case s.activity when 'Idle' then 1 end) as idle, + count(case s.activity when 'Suspended' then 1 end) as suspended from slot as s -left outer join slot_stats as c on c.id = s.stats_curr_id where s.remote_owner like '{user_name}@%'