projects / working / Evergreen.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: 0f0f6c1) | patch
LP#1315552 Don't use circ_lib name in ranked_volumes user/dbwells/lp1315552_fix_duplicates_in_ranked_volumes
authorDan Wells <dbw2@calvin.edu>
Tue, 10 May 2016 19:41:54 +0000 (15:41 -0400)
committerDan Wells <dbw2@calvin.edu>
Tue, 10 May 2016 20:06:22 +0000 (16:06 -0400)
commitcad54ce4187de1d9fcd8a90a34afe8194ebb8f30
tree7356e73641d8ff664cea0749b5c03730faf48b6ftree
parent0f0f6c13effb05c0fb88a5485b615b57d0acc9f6commit | diff
LP#1315552 Don't use circ_lib name in ranked_volumes

ranked_volumes() is supposed to return only volume info, but the name
returned was from copy.circ_lib, not acn.owning_lib, so it could result
in duplicate rows if circ_lib's varied across a single acn.

Let's just use the owning_lib name instead.  Note: the circ_lib join
is left undisturbed to keep the current sorting behavior
(necessary?).

Signed-off-by: Dan Wells <dbw2@calvin.edu>
Open-ILS/src/sql/Pg/990.schema.unapi.sql diff | blob | history
Open-ILS/src/sql/Pg/upgrade/XXXX.function.unapi.ranked_volumes.sql [new file with mode: 0644] blob
Evergreen ILS