From 996c5e85555e2eb00ea80b44e741a5c4c484b877 Mon Sep 17 00:00:00 2001 From: Mike Rylander Date: Thu, 20 Sep 2018 11:00:22 -0400 Subject: [PATCH] LP#1792621: Fix think-o in Hold Shelf Delay YAOUS test Signed-off-by: Mike Rylander Signed-off-by: Rogan Hamby Signed-off-by: Ben Shum --- .../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 527f029158..872b78d795 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 @@ -2169,7 +2169,7 @@ SELECT h.id, h.request_time, h.capture_time, h.fulfillment_time, h.checkin_time WHEN h.capture_time IS NULL THEN 2 WHEN cp.status = 6 THEN 3 WHEN EXTRACT(EPOCH FROM COALESCE(NULLIF(BTRIM(hold_wait_time.value,'"'),''),'0 seconds')::INTERVAL) = 0 THEN 4 - WHEN NOW() + COALESCE(NULLIF(BTRIM(hold_wait_time.value,'"'),''),'0 seconds')::INTERVAL > NOW() THEN 5 + WHEN h.shelf_time + COALESCE(NULLIF(BTRIM(hold_wait_time.value,'"'),''),'0 seconds')::INTERVAL > NOW() THEN 5 ELSE 4 END AS hold_status, -- 2.43.2