From 0c4238dfce4cf2375ff02099b6dab55b692ec8a4 Mon Sep 17 00:00:00 2001 From: Mike Rylander Date: Thu, 30 Aug 2018 16:37:21 -0400 Subject: [PATCH] LP#1712854: Include shelf-expired holds in the "clearable" set Signed-off-by: Mike Rylander Signed-off-by: Kathy Lussier Signed-off-by: Bill Erickson --- .../lib/OpenILS/Application/Storage/Publisher/action.pm | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/Open-ILS/src/perlmods/lib/OpenILS/Application/Storage/Publisher/action.pm b/Open-ILS/src/perlmods/lib/OpenILS/Application/Storage/Publisher/action.pm index 46a9ed023c..238746ce31 100644 --- a/Open-ILS/src/perlmods/lib/OpenILS/Application/Storage/Publisher/action.pm +++ b/Open-ILS/src/perlmods/lib/OpenILS/Application/Storage/Publisher/action.pm @@ -2173,7 +2173,7 @@ SELECT h.id, h.request_time, h.capture_time, h.fulfillment_time, h.checkin_time ELSE 5 END AS hold_status, - (h.cancel_time IS NOT NULL OR (h.current_shelf_lib IS NOT NULL AND h.current_shelf_lib <> h.pickup_lib)) AS clear_me, + (h.shelf_expire_time < NOW() OR h.cancel_time IS NOT NULL OR (h.current_shelf_lib IS NOT NULL AND h.current_shelf_lib <> h.pickup_lib)) AS clear_me, (h.usr <> h.requestor) AS is_staff_hold, -- 2.43.2