LP#1743639: opac_visible on acplg is not what it seems
authorMike Rylander <mrylander@gmail.com>
Tue, 16 Jan 2018 19:39:08 +0000 (14:39 -0500)
committerKathy Lussier <klussier@masslnc.org>
Wed, 17 Jan 2018 18:12:47 +0000 (13:12 -0500)
commit02cfe27d07cf93b612825e45a6975bcb2d5e80b8
treea0882a07f85c7ed2f67a0f1bfce268f780a19fc6
parent56bcda57b3d8a364abc883afe9e27563bef8f6cd
LP#1743639: opac_visible on acplg is not what it seems

The asset.copy_location_group table has a column called opac_visible.
However, unlike other tables with a column of that name, it controls the
visibility of the location group itself, not the visibility of the copies
within the group.  This is regretable because the 3.0+ search code thinks
that it should hide copies.

This commit adjusts the default location group filter applied to patron
searches so that they act as expected.

Signed-off-by: Mike Rylander <mrylander@gmail.com>
Signed-off-by: Kathy Lussier <klussier@masslnc.org>
Open-ILS/src/sql/Pg/300.schema.staged_search.sql
Open-ILS/src/sql/Pg/upgrade/XXXX.function.copy_location_group_visible.sql [new file with mode: 0644]