From df9336dc00b1b91b66b5c836651ae616b658691f Mon Sep 17 00:00:00 2001 From: miker Date: Tue, 21 Aug 2007 00:34:00 +0000 Subject: [PATCH] AGE was giving strange results, switched to simple addition git-svn-id: svn://svn.open-ils.org/ILS/trunk@7708 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- Open-ILS/src/perlmods/OpenILS/Application/Storage/Publisher/action.pm | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/Open-ILS/src/perlmods/OpenILS/Application/Storage/Publisher/action.pm b/Open-ILS/src/perlmods/OpenILS/Application/Storage/Publisher/action.pm index 2de972d9e1..4d7a79ec11 100644 --- a/Open-ILS/src/perlmods/OpenILS/Application/Storage/Publisher/action.pm +++ b/Open-ILS/src/perlmods/OpenILS/Application/Storage/Publisher/action.pm @@ -183,7 +183,7 @@ sub nearest_hold { my $pl = shift; my $cp = shift; my $limit = int(shift()) || 10; - my $age = shift() || '0 seconds'; + my $age = shift() || '0'; my $age_where = ''; if ($age) { @@ -196,7 +196,7 @@ sub nearest_hold { JOIN actor.org_unit_proximity p ON (p.from_org = h.pickup_lib) WHERE hm.target_copy = ? AND p.to_org = ? - AND AGE(h.request_time) > ? + AND h.request_time + ? < NOW() AND h.capture_time IS NULL AND h.cancel_time IS NULL ORDER BY -- 2.11.0