[Koha-bugs] [Bug 33761] Holds queue is not selecting items with completed transfers

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

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

--- Comment #2 from Nick Clemens <nick at bywatersolutions.com> ---
Created attachment 151387
  -->
https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=151387&action=edit
Bug 33761: Alter query to remove items with active transfers from available
list

Current code removes all items without an active transfer, and any with
completed transfers.

This patch moves the conditionals for transfers into the join, then adds a new
condition to remove items with active transfers.

To test:
1 - Apply unit test patch only
2 - prove -v t/db_dependent/HoldsQueue.t
3 - It fails
4 - Apply second patch
5 - prove -v t/db_dependent/HoldsQueue.t
6 - Success!

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