java/code/src/com/redhat/rhn/common/db/datasource/xml/Task_queries.xml | 2 ++
1 file changed, 2 insertions(+)
New commits:
commit 8c2c54cbf256658560919bf2f45fa6b1e5baa831
Author: Justin Sherrill <jsherril(a)redhat.com>
Date: Thu Sep 23 16:05:41 2010 -0400
redundancy is the spice of life, adding back rhnServer to table joins since its not so
redundant. Reverts 9f09cf8bb9854c9f8bc6f4e497a49abec3affee2
diff --git a/java/code/src/com/redhat/rhn/common/db/datasource/xml/Task_queries.xml
b/java/code/src/com/redhat/rhn/common/db/datasource/xml/Task_queries.xml
index e62234c..145fb7f 100644
--- a/java/code/src/com/redhat/rhn/common/db/datasource/xml/Task_queries.xml
+++ b/java/code/src/com/redhat/rhn/common/db/datasource/xml/Task_queries.xml
@@ -379,6 +379,8 @@ ORDER BY next_action DESC
ON snv.server_id = urn.server_id
JOIN rhnServerChannel sc
ON sc.server_id = snv.server_id
+ JOIN rhnServer S
+ ON S.id = SC.server_id
WHERE sc.channel_id = :channel_id
AND snv.errata_id = :errata_id
AND S.org_id = :org_id
Show replies by date