java/code/src/com/redhat/rhn/common/db/datasource/xml/SystemGroup_queries.xml | 6
+++---
1 file changed, 3 insertions(+), 3 deletions(-)
New commits:
commit b0b4c2d7e0a0bf55c50d996a35f05d4f6703d0c3
Author: Justin Sherrill <jsherril(a)redhat.com>
Date: Tue Nov 3 13:12:14 2009 -0500
531645 - fixing query with mistaken id reference
diff --git a/java/code/src/com/redhat/rhn/common/db/datasource/xml/SystemGroup_queries.xml
b/java/code/src/com/redhat/rhn/common/db/datasource/xml/SystemGroup_queries.xml
index 62c7868..03bc8d2 100644
--- a/java/code/src/com/redhat/rhn/common/db/datasource/xml/SystemGroup_queries.xml
+++ b/java/code/src/com/redhat/rhn/common/db/datasource/xml/SystemGroup_queries.xml
@@ -26,7 +26,7 @@
and exists (select 1 from rhnServerNeededErrataCache SNPC, rhnServerGroupMembers
SGM
where snpc.errata_id = e.id
and snpc.server_id = sgm.server_id
- and sgm.server_group_id = 5)
+ and sgm.server_group_id = G.id)
and rownum = 1) AS SECURITY_ERRATA,
( select /*+first_rows*/ 1
FROM rhnErrata E
@@ -34,7 +34,7 @@
and exists (select 1 from rhnServerNeededErrataCache SNPC, rhnServerGroupMembers
SGM
where snpc.errata_id = e.id
and snpc.server_id = sgm.server_id
- and sgm.server_group_id = 5)
+ and sgm.server_group_id = G.id)
and rownum = 1) AS BUG_ERRATA,
( select /*+first_rows*/ 1
FROM rhnErrata E
@@ -42,7 +42,7 @@
and exists (select 1 from rhnServerNeededErrataCache SNPC, rhnServerGroupMembers
SGM
where snpc.errata_id = e.id
and snpc.server_id = sgm.server_id
- and sgm.server_group_id = 5)
+ and sgm.server_group_id = G.id)
and rownum = 1) AS ENHANCEMENT_ERRATA
FROM rhnServerGroup G, rhnUserManagedServerGroups UMSG
WHERE G.ORG_ID = :org_id
Show replies by date