java/code/src/com/redhat/rhn/common/db/datasource/xml/Package_queries.xml | 2 ++
1 file changed, 2 insertions(+)
New commits:
commit 1168f61a9d16b42b533a21513c8538529862e745
Author: Tomas Lestach <tlestach(a)redhat.com>
Date: Wed Oct 31 15:05:27 2012 +0100
839960 - fix system.listLatestUpgradablePackages API to list upgradable packages from
server channels only
diff --git a/java/code/src/com/redhat/rhn/common/db/datasource/xml/Package_queries.xml
b/java/code/src/com/redhat/rhn/common/db/datasource/xml/Package_queries.xml
index d3a48c0..a71dfcf 100644
--- a/java/code/src/com/redhat/rhn/common/db/datasource/xml/Package_queries.xml
+++ b/java/code/src/com/redhat/rhn/common/db/datasource/xml/Package_queries.xml
@@ -867,6 +867,8 @@ ORDER BY UPPER(PN.name)
GROUP BY p.name_id) u
JOIN rhnPackageEvr e ON e.evr = u.max_evr
JOIN rhnPackage p ON p.name_id = u.name_id AND p.evr_id = e.id
+ JOIN rhnChannelPackage cp ON cp.package_id = p.id
+ JOIN rhnServerChannel sc ON sc.channel_id = cp.channel_id AND sc.server_id = :sid
JOIN rhnPackageArch a ON a.id = p.package_arch_id
) up,
rhnPackageUpgradeArchCompat puac