reporting/reports/data/system-currency | 2 -- 1 file changed, 2 deletions(-)
New commits: commit 8d748d37826d01f58a64af9a08d90815e062e9e9 Author: Tomas Kasparek tkasparek@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
spacewalk-commits@lists.fedorahosted.org