projects / working / Evergreen.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: 4b11fba) | patch
LP#1773479 Show Located URIs in browse user/dbwells/lp1773479_located_uri_browse
authorDan Wells <dbw2@calvin.edu>
Fri, 9 Nov 2018 17:28:08 +0000 (12:28 -0500)
committerDan Wells <dbw2@calvin.edu>
Fri, 9 Nov 2018 17:28:08 +0000 (12:28 -0500)
commit020c08d4c2adf4a9b8448928bdc485067257f26a
tree28756568a61879ef74bf28d2c77b8e8346d58210tree
parent4b11fba6c4ef7b4f15c6bf823dbfa7db570c8510commit | diff
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>
Open-ILS/src/sql/Pg/300.schema.staged_search.sql diff | blob | history
Open-ILS/src/sql/Pg/upgrade/XXXX.function.located_uri_browse_visibility.sql [new file with mode: 0644] blob
Evergreen ILS