From 531865668c2b241c300fa08360d86037f55fda14 Mon Sep 17 00:00:00 2001 From: Galen Charlton Date: Thu, 25 Feb 2016 14:32:31 -0500 Subject: [PATCH] LP#1549505: fix bug in rating.circs_over_time 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 9d668c422d..d9cdb11491 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 @@ -398,7 +398,7 @@ BEGIN SELECT bib, SUM( circs * GREATEST( iscale * (iage - cage), 1.0 )) FROM ( - SELECT b.id AS bib, + SELECT cn.record AS bib, (1 + EXTRACT(EPOCH FROM c.xact_start) / iint)::INT AS cage, COUNT(c.id)::INT AS circs FROM action.circulation c -- 2.11.0