From 059fdf35d71e337e17a6ed034c43768bf6c4aad6 Mon Sep 17 00:00:00 2001 From: Galen Charlton Date: Fri, 25 Mar 2016 14:15:46 -0400 Subject: [PATCH] LP#1549505: base holds_placed_over_time() on request age As opposed to how long ago it was fulfilled. Signed-off-by: Galen Charlton --- Open-ILS/src/sql/Pg/upgrade/XXXX.schema.statisitcal-ratings.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.statisitcal-ratings.sql b/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.statisitcal-ratings.sql index 1385d4509f..df5c8a3cbc 100644 --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.statisitcal-ratings.sql +++ b/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.statisitcal-ratings.sql @@ -602,7 +602,7 @@ BEGIN SUM( holds * GREATEST( iscale * (iage - hage), 1.0 )) FROM ( SELECT f.id AS bib, - (1 + EXTRACT(EPOCH FROM AGE(h.fulfillment_time)) / iint)::INT AS hage, + (1 + EXTRACT(EPOCH FROM AGE(h.request_time)) / iint)::INT AS hage, COUNT(h.id)::INT AS holds FROM action.hold_request h JOIN reporter.hold_request_record rhrr ON (rhrr.id = h.id) -- 2.11.0