From ae78fe70d15c2e9b88a091b5d2113e39fb354e53 Mon Sep 17 00:00:00 2001 From: Dan Scott Date: Wed, 21 Jan 2015 10:19:58 -0500 Subject: [PATCH] Handle Laurentian records a little cleaner Signed-off-by: Dan Scott --- Open-ILS/src/sql/Pg/update_marc_records_in_database.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/Open-ILS/src/sql/Pg/update_marc_records_in_database.sql b/Open-ILS/src/sql/Pg/update_marc_records_in_database.sql index 8d9ba26b10..214ca271d8 100644 --- a/Open-ILS/src/sql/Pg/update_marc_records_in_database.sql +++ b/Open-ILS/src/sql/Pg/update_marc_records_in_database.sql @@ -217,7 +217,7 @@ DECLARE next_id BIGINT; BEGIN SELECT id INTO last_id FROM conifer.conifer.enriched_bre ORDER BY id DESC LIMIT 1; - SELECT record INTO next_id FROM asset.call_number WHERE record > last_id AND deleted IS FALSE AND owning_lib IN (103, 105, 131, 150) ORDER BY record LIMIT 1; + SELECT record INTO next_id FROM asset.call_number WHERE record > last_id AND deleted IS FALSE AND owning_lib IN (SELECT id FROM actor.org_unit WHERE (id IN (102, 105) OR parent_ou IN (102, 105))) ORDER BY record LIMIT 1; UPDATE biblio.record_entry SET marc = conifer.enrich_uris(next_id), edit_date = NOW() WHERE id = next_id; INSERT INTO conifer.enriched_bre (id, success, result) VALUES (next_id, TRUE, NULL); RETURN next_id; -- 2.11.0