web/modules/rhn/RHN/DB/DataSource/xml/System_queries.xml | 3 ++-
1 file changed, 2 insertions(+), 1 deletion(-)
New commits:
commit 4aadef0fdfc48ee8a94e00fe440d16bdcbee3933
Author: Tomas Lestach <tlestach(a)redhat.com>
Date: Fri Apr 29 10:59:22 2011 +0200
fixing system query systems_with_package
I broke the query with 557f4c9b0131e31707a9b51227302d00dc1e1692
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 4400d10..72463fc 100644
--- a/web/modules/rhn/RHN/DB/DataSource/xml/System_queries.xml
+++ b/web/modules/rhn/RHN/DB/DataSource/xml/System_queries.xml
@@ -361,7 +361,8 @@ ORDER BY UPPER(NVL(S.NAME, '(none)')), S.ID
<mode name="systems_with_package">
<query params="pid, user_id">
SELECT SP.server_id AS id
- FROM rhnServerPackage SP
+ FROM rhnServerPackage SP,
+ rhnPackage P
WHERE P.id = :pid
AND P.name_id = SP.name_id
AND P.evr_id = SP.evr_id
Show replies by date