Bug 24295: Remove GetTransfers call from C4/HoldsQueue.pm
authorMartin Renvoize <martin.renvoize@ptfs-europe.com>
Tue, 16 Mar 2021 10:12:39 +0000 (10:12 +0000)
committerTomas Cohen Arazi <tomascohen@theke.io>
Fri, 26 Aug 2022 18:42:43 +0000 (15:42 -0300)
commit68f54437a3e5050474d007434b2acc13bc3494ce
treed415fc1f939c2739c7e668c64a277ecbfcb43d37
parentaa8a9f660c3148a570882c7f4ef90154734dc75b
Bug 24295: Remove GetTransfers call from C4/HoldsQueue.pm

This patch removes the GetTransfers call from
GetItemsAvailableToFillHoldRequestsForBib instead replacing it with an
inline JOIN in the initial query.

Test plan
1/ Run the holds queue
2/ Check the results
3/ Put one of the items in the holds queue into transit
4/ Run the holds queue again
5/ Check that the results do not contain the item that is in transit
6/ Apply the patch
7/ Run the holds queue again
8/ Check that the results still do not contain the item that is in
transit

Rebased-by: Joonas Kylmälä <joonas.kylmala@iki.fi>
Signed-off-by: Joonas Kylmälä <joonas.kylmala@iki.fi>
Signed-off-by: Martin Renvoize <martin.renvoize@ptfs-europe.com>
Signed-off-by: Tomas Cohen Arazi <tomascohen@theke.io>
C4/HoldsQueue.pm