fixing CN holds import
authormiker <miker@dcc99617-32d9-48b4-a31d-7c20da2025e4>
Sun, 6 Aug 2006 02:50:55 +0000 (02:50 +0000)
committermiker <miker@dcc99617-32d9-48b4-a31d-7c20da2025e4>
Sun, 6 Aug 2006 02:50:55 +0000 (02:50 +0000)
git-svn-id: svn://svn.open-ils.org/ILS/trunk@5317 dcc99617-32d9-48b4-a31d-7c20da2025e4

Evergreen/src/extras/import/legacy_hold.sql

index 2c6445b..47308e7 100644 (file)
@@ -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,