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>
Sun, 11 Mar 2012 01:06:34 +0000 (20:06 -0500)
commit267fe5f223bb1dfdf005c9f48d0ff10f9f5a1d7a
tree4798a92f04acb665c4e0e1ac51d93a76bc454ced
parentbe9051b2ff06f91336a084f0544c9cc326a54867
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