Bug 30730: (follow-up) Simplify query
authorMartin Renvoize <martin.renvoize@ptfs-europe.com>
Thu, 19 May 2022 14:52:21 +0000 (15:52 +0100)
committerFridolin Somers <fridolin.somers@biblibre.com>
Mon, 23 May 2022 18:52:40 +0000 (08:52 -1000)
commitc3f285220917847bc06cf998c7760ffd11903b69
tree1c5488a5c2ed732ae97ef51fd96a917bdb857963
parentfdfb75eaf644ed920cf0d4086502a4139b492e4c
Bug 30730: (follow-up) Simplify query

This patch drops the 'fetch all non-loanable items' query used in the
subsequent query as part of the 'not_in' and instead replaces it with a
simple filter on 'notforloan => 0'

Test plan
Run the included unit tests before and apply applying the followup.

Signed-off-by: Martin Renvoize <martin.renvoize@ptfs-europe.com>
Signed-off-by: Fridolin Somers <fridolin.somers@biblibre.com>
Koha/Holds.pm