From b2850f5900d00c64193d2ea4973fb9bfe347cc47 Mon Sep 17 00:00:00 2001 From: Jason Stephenson Date: Wed, 23 Jan 2013 09:39:19 -0500 Subject: [PATCH] Remove view reporter.xact_billing_totals from reporter-schema.sql. Signed-off-by: Jason Stephenson --- Open-ILS/src/sql/Pg/reporter-schema.sql | 8 -------- 1 file changed, 8 deletions(-) diff --git a/Open-ILS/src/sql/Pg/reporter-schema.sql b/Open-ILS/src/sql/Pg/reporter-schema.sql index 25532b6e03..1fc04f4084 100644 --- a/Open-ILS/src/sql/Pg/reporter-schema.sql +++ b/Open-ILS/src/sql/Pg/reporter-schema.sql @@ -271,14 +271,6 @@ SELECT id, END AS bib_record FROM action.hold_request ahr; -CREATE OR REPLACE VIEW reporter.xact_billing_totals AS -SELECT b.xact, - SUM( CASE WHEN b.voided THEN 0 ELSE amount END ) as unvoided, - SUM( CASE WHEN b.voided THEN amount ELSE 0 END ) as voided, - SUM( amount ) as total - FROM money.billing b - GROUP BY 1; - CREATE OR REPLACE VIEW reporter.xact_paid_totals AS SELECT b.xact, SUM( CASE WHEN b.voided THEN 0 ELSE amount END ) as unvoided, -- 2.11.0