Author: tmckay
Date: 2012-05-21 14:22:22 +0000 (Mon, 21 May 2012)
New Revision: 5385
Modified:
trunk/cumin/python/cumin/usergrid/model.strings
Log:
Change the query for user grid overview stats to sum running, idle and held across
submission records for an owner rather than using the submitter records.
BZ812407
Modified: trunk/cumin/python/cumin/usergrid/model.strings
===================================================================
--- trunk/cumin/python/cumin/usergrid/model.strings 2012-05-18 20:22:17 UTC (rev 5384)
+++ trunk/cumin/python/cumin/usergrid/model.strings 2012-05-21 14:22:22 UTC (rev 5385)
@@ -1,7 +1,7 @@
[LoadUserJobStats.sql]
select
- sum(s."RunningJobs") as RunningJobs,
- sum(s."IdleJobs") as IdleJobs,
- sum(s."HeldJobs") as held
-from "com.redhat.grid"."Submitter" as s
+ sum(s."Running") as RunningJobs,
+ sum(s."Idle") as IdleJobs,
+ sum(s."Held") as held
+from "com.redhat.grid"."Submission" as s
where s."Owner" = '{user_name}'
Show replies by date