Change #3491

Comments

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>
Signed-off-by: Mike Rylander <mrylander@gmail.com>

Changed files

• Open-ILS/src/sql/Pg/990.schema.unapi.sql
• Open-ILS/src/sql/Pg/upgrade/XXXX.function.unapi.ranked_volumes.sql