]> git.evergreen-ils.org Git - Evergreen.git/commit
LP#1773479 Show Located URIs in browse
authorDan Wells <dbw2@calvin.edu>
Fri, 9 Nov 2018 17:28:08 +0000 (12:28 -0500)
committerMike Rylander <mrylander@gmail.com>
Mon, 12 Nov 2018 17:27:29 +0000 (12:27 -0500)
commit1a5a9c9041d5bbd0ee7fda646d26fb22173c2929
treea8f0b89b97ccfffc6e6b77477484c49f5031934d
parent6c9b4832b156970a861603a64fa0ae22abaeb4be
LP#1773479 Show Located URIs in browse

Located URIs depend upon bib-level visibility, as there are no copies
to work with.  The browse code, however, was joining in the copy
visibility table as if it would always have at least one row per bib,
but in the case of located URIs, it does not.

Let's change it to a LEFT JOIN to allow the bib row to show up, at
which point the existing bib visibility check can do its job.

Signed-off-by: Dan Wells <dbw2@calvin.edu>
Signed-off-by: Mike Rylander <mrylander@gmail.com>
Open-ILS/src/sql/Pg/300.schema.staged_search.sql
Open-ILS/src/sql/Pg/upgrade/XXXX.function.located_uri_browse_visibility.sql [new file with mode: 0644]