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

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

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

Tomás Cohen Arazi <tomascohen at gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|Patch doesn't apply         |ASSIGNED

--- Comment #29 from Tomás Cohen Arazi <tomascohen at gmail.com> ---
(In reply to Katrin Fischer from comment #28)
> Do we have 3 alternate patches here now?

We have discussed it with Nick, and both our patches return the same results.
That's because lost won't be NULL (itemlost is defined as NOT NULL) and so
there will always be the lost index on records. The same applies to the
not-onloan-count index, which is generated on indexing. Way to test:

kohadev-koha at 180acd7da540:/kohadevbox/koha$ yaz-client
unix://var/run/koha/kohadev/bibliosocket
Connecting...OK.
Sent initrequest.
Connection accepted by v3 target.
ID     : 81
Name   : Zebra Information Server/GFS/YAZ
Version: 4.2.30 98864b44c654645bc16b2c54f822dc2e45a93031
Options: search present delSet triggerResourceCtrl scan sort extendedServices
namedResultSets
Elapsed: 0.004222
Z> base biblios
Z> querytype ccl2rpn
Z> set_cclfile /etc/koha/zebradb/ccl.properties
Z> f ( (not-onloan-count,st-numeric,ge = 1) and (lost,st-numeric=0) )
Sent searchRequest.
Received SearchResponse.
Search was a success.
Number of hits: 411, setno 1
SearchResult-1: term=1 cnt=411, term=0 cnt=411
records returned: 0
Elapsed: 0.003008
Z> f ( (allrecords,AlwaysMatches='') and (not-onloan-count,st-numeric,ge = 1)
and (lost,st-numeric=0) )
Sent searchRequest.
Received SearchResponse.
Search was a success.
Number of hits: 411, setno 2
SearchResult-1: term= cnt=436, term=1 cnt=411, term=0 cnt=411
records returned: 0
Elapsed: 0.000761
Z>

He's working on fixing the tests ATM. I will obsolete mine and Olli's.

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