]> 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:28:15 +0000 (12:28 -0500)
commit23d1cbf46853b50113529ca9c895e0ef316c1ba6
tree11a82313eafcdd08e11ac6dc5b1fef1217ac4dfb
parentdbe9a8a269d5f7b7d0b2e50787dcbdaa3a073836
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]