web/modules/rhn/RHN/DB/DataSource/xml/System_queries.xml | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-)
New commits: commit 51306522f122e9470755f200f577f4539a4e66f1 Author: Milan Zazrivec mzazrivec@redhat.com Date: Thu May 5 15:32:36 2011 +0200
682112 - correct column name
diff --git a/web/modules/rhn/RHN/DB/DataSource/xml/System_queries.xml b/web/modules/rhn/RHN/DB/DataSource/xml/System_queries.xml index 7a581d1..f9715da 100644 --- a/web/modules/rhn/RHN/DB/DataSource/xml/System_queries.xml +++ b/web/modules/rhn/RHN/DB/DataSource/xml/System_queries.xml @@ -910,7 +910,7 @@ SELECT distinct S.id, S.name WHERE S.org_id = :org_id AND S.id = SC.server_id AND SC.channel_id = CFM.channel_id - AND SC.is_flex = 'N' + AND SC.is_fve = 'N' AND CFM.channel_family_id = :cfam_id AND EXISTS (SELECT 1 FROM rhnUserServerPerms USP WHERE USP.user_id = :user_id AND USP.server_id = S.id) ORDER BY UPPER(NVL(S.NAME, '(none)')), S.ID @@ -928,7 +928,7 @@ SELECT distinct S.id, S.name WHERE S.org_id = :org_id AND S.id = SC.server_id AND SC.channel_id = CFM.channel_id - AND SC.is_flex = 'Y' + AND SC.is_fve = 'Y' AND CFM.channel_family_id = :cfam_id AND EXISTS (SELECT 1 FROM rhnUserServerPerms USP WHERE USP.user_id = :user_id AND USP.server_id = S.id) ORDER BY UPPER(NVL(S.NAME, '(none)')), S.ID