unapi: avoid deleted call numbers, copies, and sunits
authorDan Scott <dscott@laurentian.ca>
Sun, 18 Dec 2011 16:21:19 +0000 (11:21 -0500)
committerDan Scott <dan@coffeecode.net>
Thu, 15 Mar 2012 04:34:32 +0000 (00:34 -0400)
commitd3f53980df90c865de9cddfa2aa714ec3a5f5877
treeb6163718af9f4676ab8812351c8b7b274609f887
parentee84ca9724608a0dbc7c21b3aa6da017b7134aa0
unapi: avoid deleted call numbers, copies, and sunits

The rewrite of unapi removed the filters for deleted call numbers that
were added to master in LP# 893315 / commit hash 47a16f516d. Without
this filter, it is possible to return pages of results that would show
nothing in the TPAC because all of the call numbers were deleted.

This commit reinstates the check for the deleted condition on call
numbers and adds a check for the deleted condition on copies and serial
units as well.

The check could be made conditional by adding yet another parameter to
the unapi api, but there appears to be no compelling reason to make the
signature more complex for now.

Signed-off-by: Dan Scott <dscott@laurentian.ca>
Open-ILS/src/sql/Pg/990.schema.unapi.sql