java/code/src/com/redhat/rhn/common/db/datasource/xml/Channel_queries.xml | 1 +
1 file changed, 1 insertion(+)
New commits:
commit 05be4a6f4d509e55dcc9ef21d5a763ebf37f41d1
Author: Tomas Lestach <tlestach(a)redhat.com>
Date: Thu Aug 30 13:50:52 2012 +0200
851150 - make the select working on PG as well
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 60a6cfb..1bf7e32 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
@@ -507,6 +507,7 @@ ORDER BY rhn_channel.channel_priority(ACh.parent_or_self_id),
ACh.parent_or_sel
<mode name="all_channels_tree">
<query params="user_id">
SELECT distinct C.name,
+ UPPER(C.name),
UC.channel_id ID,
PC.label PARENT_CHANNEL,
C.label,
Show replies by date