projects / contrib / Conifer.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: 91201d1) | 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:18:54 +0000 (16:18 -0500)
commite6a0371eee20b373d2f09d27f0b44e712d481991
tree4c0ad7b3f797bcc106c6768296ed143a28890532tree
parent91201d1923a7498b95ab0adb7540a00636e413c3commit | 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