java/code/src/com/redhat/rhn/common/db/datasource/xml/Action_queries.xml | 8 ++++----
1 file changed, 4 insertions(+), 4 deletions(-)
New commits:
commit ee785ba386efac238bf2848f222369337623f332
Author: Stephen Herr <sherr(a)redhat.com>
Date: Wed Apr 4 10:36:13 2012 -0400
809868 - Make automatically-scheduled tasks visible on Failed and Archived tabs
diff --git a/java/code/src/com/redhat/rhn/common/db/datasource/xml/Action_queries.xml b/java/code/src/com/redhat/rhn/common/db/datasource/xml/Action_queries.xml
index b2c5416..b5162ca 100644
--- a/java/code/src/com/redhat/rhn/common/db/datasource/xml/Action_queries.xml
+++ b/java/code/src/com/redhat/rhn/common/db/datasource/xml/Action_queries.xml
@@ -217,12 +217,12 @@ SELECT DISTINCT UAO.id AS ID,
(SELECT COUNT(server_id) FROM rhnServerAction WHERE action_id = UAO.id AND status IN (0,1)) AS "IN_PROGRESS_SYSTEMS",
(SELECT COUNT(server_id) FROM rhnServerAction WHERE action_id = UAO.id AND status = 2) AS "COMPLETED_SYSTEMS",
(SELECT COUNT(server_id) FROM rhnServerAction WHERE action_id = UAO.id AND status = 3) AS "FAILED_SYSTEMS"
- FROM rhnUserActionOverview UAO, web_contact WC
+ FROM rhnUserActionOverview UAO left join
+ web_contact WC on UAO.scheduler = WC.id
WHERE UAO.org_id = :org_id
AND UAO.user_id = :user_id
AND UAO.action_status_id = 3
AND UAO.archived = 0
- AND WC.id = UAO.scheduler
ORDER BY EARLIEST DESC
</query>
@@ -242,11 +242,11 @@ SELECT DISTINCT UAO.id AS ID,
(SELECT COUNT(server_id) FROM rhnServerAction WHERE action_id = UAO.id AND status IN (0,1)) AS "IN_PROGRESS_SYSTEMS",
(SELECT COUNT(server_id) FROM rhnServerAction WHERE action_id = UAO.id AND status = 2) AS "COMPLETED_SYSTEMS",
(SELECT COUNT(server_id) FROM rhnServerAction WHERE action_id = UAO.id AND status = 3) AS "FAILED_SYSTEMS"
- FROM rhnUserActionOverview UAO, web_contact WC
+ FROM rhnUserActionOverview UAO left join
+ web_contact WC on UAO.scheduler = WC.id
WHERE UAO.org_id = :org_id
AND UAO.user_id = :user_id
AND UAO.archived = 1
- AND WC.id = UAO.scheduler
ORDER BY EARLIEST DESC
</query>