reporting/reports/data/system-currency | 2 --
1 file changed, 2 deletions(-)
New commits:
commit 8d748d37826d01f58a64af9a08d90815e062e9e9
Author: Tomas Kasparek <tkasparek(a)redhat.com>
Date: Wed Mar 20 11:29:18 2013 +0100
making system-currency work on postgres
diff --git a/reporting/reports/data/system-currency b/reporting/reports/data/system-currency
index 4a1a4f9..a8cd59d 100644
--- a/reporting/reports/data/system-currency
+++ b/reporting/reports/data/system-currency
@@ -31,7 +31,6 @@ params:
sql:
- select * from (
select system_id, org_id, name, critical, important, moderate, low, bug, enhancement,
((critical * :p_crit) + (important * :p_imp) + (moderate * :p_mod) + (low * :p_low) + (bug * :p_bug) + (enhancement * :p_enh)) as score
from (
@@ -48,7 +47,6 @@ sql:
(select distinct err.id, snc.server_id, err.synopsis, err.advisory_type from rhnErrata err join
rhnServerNeededCache SNC on err.id=SNC.errata_id) E on S.id=E.server_id
group by S.id, S.org_id, name
- )
) X
-- where placeholder
order by org_id, system_id