LP1353643 Located URIs search scoping and display
authorLiam Whalen <liam.whalen@bc.libraries.coop>
Tue, 23 Sep 2014 00:53:33 +0000 (17:53 -0700)
committerJeff Davis <jdavis@sitka.bclibraries.ca>
Wed, 29 Jul 2015 20:58:03 +0000 (13:58 -0700)
commit92e61c624c08a2eac83346e05d6c497266b71150
tree54d5537899e84293a1d08ef94623076e71b02df5
parentb8422397ff57cb4f2709db75451db8a97eb19575
LP1353643 Located URIs search scoping and display

The current system returns all URIs attached to a record.  This is too
much information when a record has a large number of 856 $u attached to
it.

This code adds new SQL functions to control the search scope of records
with URIs attached to them and the display of URIs once records have
been retrieved.

To do this 7 new libray settings have been created.

opac.luri_anc_vis_depth, which controls the depth of the ancestors
searched when retrieving URIs for a record.

opac.luri_des_vis_depth, which controls the depth of the descentants
searched when retrieving URIs for a record.

opac.luri_ancestor_record_visibility_depth, which controls the depth of
ancestors searched for relevant URIs when searching records containing
856 $u values.

opac.luri_descendants_record_visibility_depth, which controls the depth
of descendants searched for relevant URIs when searching records
containing 856 $u values.

opac.luri_pref_ancestor_record_visibility_depth, which controls the
depth of the preferred library's ancestors searched for relevant URIs
when searching records containing 856 $u values.

opac.luri_pref_descendants_record_visibility_depth, which controls the
depth of the preferred library's descendants searched for relevant URIs
when searching records containing 856 $u values.

These last two settings are needed to allow search for URIs and search
for physical copies to behave in the same mannner regarding the
preferred library.  When search for copies, the preferred library
returns copies that are attached to records belonging to the search
library, but it does not return records that belong only to the
preferred library.  Using these settings, a library can ensure that
records with 856 $u behave in the same manner.

Lastly opac.luri_results_uri_limit determines how many URIs to display
in the search results screen.  This stops too many links from being
displayed for a single result in the search results, which causes the
search results page to be too long.

At Sitka, we set the opac.luri_descendants_record_visibility_depth to
100 at the Consortia level.  This allows the search to return all
records with 856 $u. But, we set the opac.luri_des_vis_depth to 0, which
stops the search results from displaying any links at the Consortia
level. All other settings are 0 for the Consortia level.

At one branch we set the opac.luri_descendants_record_visibility_depth to
100.  But the opac.luri_desc_vis_depth is set to 4. At the same branch
the opac.luri_ancestor_record_visibility_depth is set to 2, which causes
records belonging to the system to be returned, but not records
belonging to the Consortia or the Federation.  As well,
opac.luri_anc_vis_depth is set to 2, to ensure URIs are
retrieved for any records that could be retrieved.

Added link to More results

Signed-off-by: Liam Whalen <liam.whalen@bc.libraries.coop>
Removed extra More...
Open-ILS/src/sql/Pg/020.schema.functions.sql
Open-ILS/src/sql/Pg/300.schema.staged_search.sql
Open-ILS/src/sql/Pg/950.data.seed-values.sql
Open-ILS/src/sql/Pg/990.schema.unapi.sql
Open-ILS/src/sql/Pg/upgrade/XXXX.data.luri_as_copy_settings.sql [new file with mode: 0644]
Open-ILS/src/sql/Pg/upgrade/XXXX.schema.functions.fenced_actor_org_unit_descendants.sql [new file with mode: 0644]
Open-ILS/src/sql/Pg/upgrade/XXXX.schema.functions.fenced_actor_org_unit_full_path.sql [new file with mode: 0644]
Open-ILS/src/sql/Pg/upgrade/XXXX.schema.functions.org_unit_ancestor_fenced_path.sql [new file with mode: 0644]
Open-ILS/src/sql/Pg/upgrade/XXXX.schema.staged_search.fenced_query_parser_fts.sql [new file with mode: 0644]
Open-ILS/src/sql/Pg/upgrade/XXXX.schema.unapi.fenced_located_uris.sql [new file with mode: 0644]
Open-ILS/src/templates/opac/parts/result/table.tt2