From 2d000a99466de944baa9b62ea2ac2b7ac1f4de51 Mon Sep 17 00:00:00 2001 From: Thomas Berezansky Date: Wed, 15 Oct 2014 11:32:58 -0400 Subject: [PATCH] Ensure "Reshelved" copies are still reshelving Rather than "were reshelving when the query started" Signed-off-by: Thomas Berezansky --- .../perlmods/lib/OpenILS/Application/Storage/Publisher/action.pm | 1 + 1 file changed, 1 insertion(+) 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 4a49804acc..f987d3b973 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 @@ -226,6 +226,7 @@ sub complete_reshelving { WHERE cp.status = 7 AND cp.status_changed_time < NOW() - CAST( COALESCE( BTRIM( (SELECT value FROM actor.org_unit_ancestor_setting('circ.reshelving_complete.interval', cp.circ_lib)),'"' ), ? ) AS INTERVAL) ) + AND status = 7 SQL my $sth = action::circulation->db_Main->prepare_cached($sql); $sth->execute($window); -- 2.43.2