java/code/src/com/redhat/rhn/common/db/datasource/xml/Channel_queries.xml | 7 ++++---
1 file changed, 4 insertions(+), 3 deletions(-)
New commits:
commit 1ffbf96ea6ff712ae723c00094cb01aa014a680d
Author: Partha Aji <paji(a)redhat.com>
Date: Wed Sep 22 12:12:42 2010 -0400
636587- Fixed a query showing the system counts in the Software Entitleements page
diff --git a/java/code/src/com/redhat/rhn/common/db/datasource/xml/Channel_queries.xml
b/java/code/src/com/redhat/rhn/common/db/datasource/xml/Channel_queries.xml
index 0f7fe7e..0255e9f 100644
--- a/java/code/src/com/redhat/rhn/common/db/datasource/xml/Channel_queries.xml
+++ b/java/code/src/com/redhat/rhn/common/db/datasource/xml/Channel_queries.xml
@@ -345,9 +345,10 @@ ORDER BY UPPER(C.name)
SELECT CFO.id, CFO.name, CFO.label, CFO.current_members, CFO.max_members,
CFO.has_subscription, CFO.url,
CFO.fve_current_members as current_flex, CFO.fve_max_members as max_flex,
(select count(*)
- from rhnServerChannel sc inner join
- rhnChannelFamilyMembers CFM on CFM.channel_id = sc.channel_id
- where CFM.channel_family_id = CFO.id) as subscribe_count
+ from rhnServerChannel sc
+ inner join rhnChannelFamilyMembers CFM on CFM.channel_id = sc.channel_id
+ inner join rhnServer s on s.id = sc.server_id
+ where CFM.channel_family_id = CFO.id and s.org_id = cfo.org_id) as
subscribe_count
FROM rhnChannelFamilyOverview CFO
WHERE CFO.org_id = :org_id
ORDER BY CFO.name ASC
Show replies by date