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@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