projects / contrib / Conifer.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: a6ed9cb) | patch
Full Circ Count View Amplifies Legacy Circs
authorDan Wells <dbw2@calvin.edu>
Thu, 29 Sep 2011 13:23:49 +0000 (09:23 -0400)
committerMike Rylander <mrylander@gmail.com>
Tue, 15 Nov 2011 21:24:22 +0000 (16:24 -0500)
commita3b8fb1d6057adacf9136690bfc1143c3b1dac9e
treea4061aa351069bd1e972e46826a0df5e61479629tree
parenta6ed9cb87f4ab7fe24251e46fd2506e7d19a7087commit | diff
Full Circ Count View Amplifies Legacy Circs

The current extend_reported.full_circ_count sums the legacy circ count
column, but this results in amplifying the count by the number of current
circs in the system.  This commit adds the legacy count to the GROUP BY
instead of summing it.

Signed-off-by: Dan Wells <dbw2@calvin.edu>
Signed-off-by: Mike Rylander <mrylander@gmail.com>
Open-ILS/src/sql/Pg/extend-reporter.sql diff | blob | history
Open-ILS/src/sql/Pg/upgrade/XXXX.schema.fix_full_circ_count_view.sql [new file with mode: 0644] blob
Evergreen contribs