[Koha-bugs] [Bug 11677] Limit to Only items currently available for loan or reference not working!

[bugzilla-daemon at bugs.koha-community.org]

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11677

--- Comment #8 from Olli-Antti Kivilahti <olli-antti.kivilahti at jns.fi> ---
Created attachment 32096
  -->
http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=32096&action=edit
Bug 11677 - (KD-157) Limit to Only items currently available for loan or
reference not working!

This row:
$availability_limit .=
"( ( allrecords,AlwaysMatches='' not onloan,AlwaysMatches='') and
(lost,st-numeric=0) )"; #or ( allrecords,AlwaysMatches='' not
lost,AlwaysMatches='')) )";
Causes all records in Zebra to be selected and removes records with even one
item onloan (even if items would be available)!
This is obviously wrong, but because Zebra (and not many other text indexers)
cannot deal with (If undef)-search terms,
a fix might be to set 952$q (onloan) datetime to 0000-00-00 instead of NULL in
the DB.
Then we could find Records with items where onloan is 0000-00-00.

Comments out that Zebra availability search and deals with availability on
Koha-side.

Gets the branch or holdingbranch limit from opac-search.pl or search.pl and
uses that to skip Zebra results which
are onloan or notforloan.
Updates the result set size when results are removed.

-- 
You are receiving this mail because:
You are watching all bug changes.