From 42268232ba8e2d0d670a16faeca3798fa0090302 Mon Sep 17 00:00:00 2001 From: miker Date: Sat, 2 Dec 2006 02:47:17 +0000 Subject: [PATCH] typo git-svn-id: svn://svn.open-ils.org/ILS/trunk@6645 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- Open-ILS/src/sql/Pg/reporter-schema.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/Open-ILS/src/sql/Pg/reporter-schema.sql b/Open-ILS/src/sql/Pg/reporter-schema.sql index 529dc17b90..55c6e57551 100644 --- a/Open-ILS/src/sql/Pg/reporter-schema.sql +++ b/Open-ILS/src/sql/Pg/reporter-schema.sql @@ -190,7 +190,7 @@ SELECT id, END AS bib_record FROM action.hold_request ahr; -CREATE OR REPLACE VIEW reporter.xact_billed_totals AS +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, -- 2.11.0