java/code/src/com/redhat/rhn/common/db/datasource/xml/SystemGroup_queries.xml | 6
++++--
1 file changed, 4 insertions(+), 2 deletions(-)
New commits:
commit d10471dd873d2cd8ec05bd831146dc2940c922aa
Author: Justin Sherrill <jsherril(a)redhat.com>
Date: Thu Jul 29 14:57:20 2010 -0400
603133 - fixing issue where system within a group that were unentitled would still
factor into whether the group would show up with an exclamation point
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 f72d2b2..f0bf857 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
@@ -29,8 +29,10 @@
1, 'Product Enhancement Advisory') as type_value
from rhnErrata E inner join
rhnServerNeededCache SNPC on E.id = SNPC.errata_id inner
join
- rhnServerGroupMembers SGM on SGM.server_id = SNPC.server_id
- where sgm.server_group_id = G.id) as MOST_SEVERE_ERRATA
+ rhnServerGroupMembers SGM on SGM.server_id = SNPC.server_id
inner join
+ rhnServerFeaturesView SFV on SGM.server_id = SFV.server_id
+ where sgm.server_group_id = G.id
+ AND SFV.label = 'ftr_system_grouping') as
MOST_SEVERE_ERRATA
FROM rhnServerGroup G, rhnUserManagedServerGroups UMSG
WHERE G.ORG_ID = :org_id
AND UMSG.user_id = :user_id
Show replies by thread