reporting/reports/data/packages-updates-all | 2 +-
1 file changed, 1 insertion(+), 1 deletion(-)
New commits:
commit 23ffc4542907d4dd3a0932e6c800baf73031634f
Author: Tomas Kasparek <tkasparek(a)redhat.com>
Date: Thu Sep 26 14:15:16 2013 +0200
select from rhnServerNeededCache instead of rhnServerNeededPackageCache
no need to select from rhnServerNeededPackageCache view - all info needed is in
rhnServerNeededCache
diff --git a/reporting/reports/data/packages-updates-all
b/reporting/reports/data/packages-updates-all
index b718f2c..f08d000 100644
--- a/reporting/reports/data/packages-updates-all
+++ b/reporting/reports/data/packages-updates-all
@@ -34,7 +34,7 @@ sql:
NPE.version as newer_version,
NPE.release as newer_release
from rhnServer S
- join rhnServerNeededPackageCache SPC on S.id=SPC.server_id
+ join rhnServerNeededCache SPC on S.id=SPC.server_id
join rhnPackage P on SPC.package_id=P.id
join rhnPackageName PN on P.name_id=PN.id
join rhnServerPackage SP on SP.server_id=S.id and SP.name_id=P.name_id
Show replies by date