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>
Sat, 17 Mar 2012 18:24:38 +0000 (14:24 -0400)
commitdcf171f58ba37d347d4ec4d0d3182218a575bb91
treef6ad96cf075d6790a3c29a52ee7405afb5c3009a
parent25fc4c371bcfc3b3c68b6f727c9667533728624d
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