web/modules/rhn/RHN/DB/DataSource/xml/Channel_queries.xml | 4 ++--
1 file changed, 2 insertions(+), 2 deletions(-)
New commits:
commit 8b8d7037c9667432b41c6dbedab509e43f273b04
Author: Shannon Hughes <shughes(a)redhat.com>
Date: Thu Apr 30 17:15:19 2009 -0400
492588 - changed query to use rhnSharedChannelView to support shared channels in
activation keys
diff --git a/web/modules/rhn/RHN/DB/DataSource/xml/Channel_queries.xml
b/web/modules/rhn/RHN/DB/DataSource/xml/Channel_queries.xml
index 32000de..b3b446c 100644
--- a/web/modules/rhn/RHN/DB/DataSource/xml/Channel_queries.xml
+++ b/web/modules/rhn/RHN/DB/DataSource/xml/Channel_queries.xml
@@ -349,10 +349,10 @@ SELECT ACh.channel_name NAME, ACh.channel_id ID, ACh.channel_depth
AS DEPTH,
WHERE CF.id = CFM.channel_family_id
AND CFM.channel_id = ACh.channel_id) CHANNEL_FAMILY_LABEL,
(SELECT COUNT(C2.id)
- FROM rhnChannel C2
+ FROM rhnSharedChannelView C2
WHERE C2.parent_channel = C.id) CHILDREN, ACh.parent_or_self_label,
ACh.channel_label,
AT.label PACKAGING_TYPE
- FROM rhnArchType AT, rhnChannelArch CA, rhnChannel C, rhnAvailableChannels ACh
+ FROM rhnArchType AT, rhnChannelArch CA, rhnSharedChannelView C, rhnAvailableChannels
ACh
WHERE ACh.org_id = :org_id
AND C.id = ACh.channel_id
AND CA.id = C.channel_arch_id
Show replies by date