From e275d51a9342083eeb7721d1b06698206e2d5c02 Mon Sep 17 00:00:00 2001 From: Rogan Hamby Date: Thu, 25 Jul 2019 11:05:52 -0400 Subject: [PATCH] replacing the 'current use' with static zero because it is being used as renewals and renewals circs are being double counted since they are also in the circ count --- collectionHQ/functions.sql | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) diff --git a/collectionHQ/functions.sql b/collectionHQ/functions.sql index a181121..23337f9 100644 --- a/collectionHQ/functions.sql +++ b/collectionHQ/functions.sql @@ -176,7 +176,8 @@ CREATE OR REPLACE FUNCTION collectionHQ.write_item_rows_to_stdout (TEXT, INT) RE || COALESCE(collectionHQ.quote(bar_code), '') || ',' || COALESCE(collectionHQ.quote(last_use_date), '') || ',' || COALESCE(cumulative_use_total, '') || ',' - || COALESCE(cumulative_use_current, '') || ',' + --|| COALESCE(cumulative_use_current, '') || ',' + || '0 ,' || COALESCE(collectionHQ.quote(status), '') || ',' || COALESCE(collectionHQ.quote(date_added), '') || ',' || COALESCE(price, '') || ',' -- 2.11.0