From e282a375723a842c3dd5124d3d13fccef2933918 Mon Sep 17 00:00:00 2001 From: miker Date: Sun, 6 Aug 2006 02:50:55 +0000 Subject: [PATCH] fixing CN holds import git-svn-id: svn://svn.open-ils.org/ILS/trunk@5317 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- Evergreen/src/extras/import/legacy_hold.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/Evergreen/src/extras/import/legacy_hold.sql b/Evergreen/src/extras/import/legacy_hold.sql index 2c6445bcc6..47308e7939 100644 --- a/Evergreen/src/extras/import/legacy_hold.sql +++ b/Evergreen/src/extras/import/legacy_hold.sql @@ -47,7 +47,7 @@ INSERT INTO action.hold_request ELSE 2 END AS selection_depth, lh.hold_date AS request_time, - CASE WHEN lh.available = 'Y' THEN now() + CASE WHEN lh.available IN ('Y','I') THEN now() ELSE NULL END AS capture_time, rou.id AS request_lib, -- 2.43.2