allowing per-org_unit reshelving complete setting
authormiker <miker@dcc99617-32d9-48b4-a31d-7c20da2025e4>
Thu, 2 Oct 2008 00:56:44 +0000 (00:56 +0000)
committermiker <miker@dcc99617-32d9-48b4-a31d-7c20da2025e4>
Thu, 2 Oct 2008 00:56:44 +0000 (00:56 +0000)
git-svn-id: svn://svn.open-ils.org/ILS/trunk@10746 dcc99617-32d9-48b4-a31d-7c20da2025e4

Open-ILS/src/perlmods/OpenILS/Application/Storage/Publisher/action.pm

index e324ac1..09214c4 100644 (file)
@@ -142,7 +142,7 @@ sub complete_reshelving {
                       WHERE circ.checkin_time IS NOT NULL
                             AND cp.status = 7
                       GROUP BY 1
-                      HAVING MAX(circ.checkin_time) < NOW() - CAST( COALESCE( BTRIM( setting.value,'"' ), ? )  AS INTERVAL)
+                      HAVING MAX(circ.checkin_time) < NOW() - CAST( COALESCE( BTRIM( FIRST(setting.value),'"' ), ? )  AS INTERVAL)
                     ) AS foo
                                 UNION ALL
             SELECT  cp.id