]> git.evergreen-ils.org Git - working/Evergreen.git/commit
LP893315: Do not return delected call numbers in holdings_xml
authorDan Scott <dscott@laurentian.ca>
Fri, 25 Nov 2011 18:20:32 +0000 (13:20 -0500)
committerBill Erickson <berick@esilibrary.com>
Tue, 6 Dec 2011 14:54:00 +0000 (09:54 -0500)
commit47a16f516d5bf3cdd3d22b14821b7500e092465a
tree9ca803aac9d88f9c01b4d098f418744f11d1802d
parent27e32d09248a684e6291dd0aca5af4408271a352
LP893315: Do not return delected call numbers in holdings_xml

Per LP893315, deleted call numbers were obscuring the actual active URIs
associated with a given bib record in a given scope at the default limit
of 5 results per record in unapi.holdings_xml.

Filtering out the deleted call numbers from the results seems like a
good idea, as we're generally interested in only showing the active
results (at least as in-db unapi is currently used). This also addresses
the problem of not showing active URIs when there are active URIs to
display.

Signed-off-by: Dan Scott <dscott@laurentian.ca>
Signed-off-by: Bill Erickson <berick@esilibrary.com>
Open-ILS/src/sql/Pg/990.schema.unapi.sql
Open-ILS/src/sql/Pg/upgrade/XXXX.LP893315_schema.function.filter_deleted_acns_from_unapi.holdings_xml.sql [new file with mode: 0644]