From ad4a4755eb9ad49d9ce3cc3001ec99df68cbcc31 Mon Sep 17 00:00:00 2001 From: Chris Sharp Date: Wed, 28 Sep 2016 13:50:57 -0400 Subject: [PATCH] More corrections. Signed-off-by: Chris Sharp --- Open-ILS/src/sql/Pg/example.reporter-extension.sql | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) diff --git a/Open-ILS/src/sql/Pg/example.reporter-extension.sql b/Open-ILS/src/sql/Pg/example.reporter-extension.sql index 910bb3e7e5..584d89de6c 100644 --- a/Open-ILS/src/sql/Pg/example.reporter-extension.sql +++ b/Open-ILS/src/sql/Pg/example.reporter-extension.sql @@ -397,6 +397,7 @@ CREATE VIEW reporter.acq_invoice_view AS FROM acq.lineitem_detail acqlid WHERE acqlid.lineitem = li.id AND cancel_reason IS NULL) AS quantity_ordered, + -- this is still wrong :-/ (SELECT sum(estimated_unit_price) FROM acq.lineitem acqli WHERE inv_entry.lineitem = acqli.id) AS lineitem_total, @@ -428,7 +429,7 @@ CREATE VIEW reporter.acq_invoice_view AS WHERE acqii.invoice = inv.id) AS inv_item_total, (SELECT COUNT(*) FROM acq.lineitem acqli - WHERE inv_entry.lineitem = acqli.id) AS lineitem_count, + WHERE inv_entry.lineitem = acqli.id) AS lineitem_count FROM acq.invoice inv INNER JOIN acq.provider provider ON (inv.provider = provider.id) INNER JOIN acq.provider shipper ON (inv.shipper = shipper.id) -- 2.11.0