]> git.koha-community.org Git - koha.git/commit
Bug 33761: Alter query to remove items with active transfers from available list
authorNick Clemens <nick@bywatersolutions.com>
Thu, 18 May 2023 11:09:18 +0000 (11:09 +0000)
committerMatt Blenkinsop <matt.blenkinsop@ptfs-europe.com>
Thu, 8 Jun 2023 16:34:45 +0000 (16:34 +0000)
commitd322e76606b8a70a935684c7cbd858eeb960a0f4
tree0ed4d95c96e8623d6d945b45779054cdec857ffb
parent90579d3c614f99ab1d254e41f4cca8002dd01eba
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!

Signed-off-by: Martin Renvoize <martin.renvoize@ptfs-europe.com>
Signed-off-by: Tomas Cohen Arazi <tomascohen@theke.io>
(cherry picked from commit d95312328dc83aa98728ac77ef55104ea820adfd)
Signed-off-by: Matt Blenkinsop <matt.blenkinsop@ptfs-europe.com>
C4/HoldsQueue.pm