From a3de9fe5c9527f993b6d51e7ca51a4d7805fe679 Mon Sep 17 00:00:00 2001 From: Bill Erickson Date: Thu, 17 Jan 2019 10:32:40 -0500 Subject: [PATCH] JBAS-2138 Patron search grid column configs * Create requested layout config * Create org setting type to store the value * Remove the analogous workstation setting type to prevent storing overrides to column configs. Signed-off-by: Bill Erickson --- KCLS/sql/schema/deploy/3.2-additions.sql | 16 ++++++++++++++++ 1 file changed, 16 insertions(+) diff --git a/KCLS/sql/schema/deploy/3.2-additions.sql b/KCLS/sql/schema/deploy/3.2-additions.sql index 7092996aad..a5da53061b 100644 --- a/KCLS/sql/schema/deploy/3.2-additions.sql +++ b/KCLS/sql/schema/deploy/3.2-additions.sql @@ -19,6 +19,22 @@ BEGIN INSERT INTO actor.workstation (owning_lib, name) VALUES (1531, 'PR-Connexion-Stream'); + -- Move the patron search grid workstation setting to an + -- org unit setting (to lock it down) and provide a config. + INSERT INTO config.org_unit_setting_type + (name ,grp ,label ,description ,datatype) + SELECT name, grp, label, description, datatype + FROM config.workstation_setting_type + WHERE name = 'eg.grid.circ.patron.search'; + + INSERT INTO actor.org_unit_setting (org_unit, name, value) + VALUES (1, 'eg.grid.circ.patron.search', + '{"limit":25,"columns":[{"name":"family_name","flex":3},{"name":"first_given_name","flex":3},{"name":"second_given_name"},{"name":"dob"},{"name":"card.barcode"},{"name":"mailing_address.street1","flex":6},{"name":"mailing_address.city","flex":3},{"flex":3,"name":"day_phone"},{"name":"email","flex":3}],"version":2}'); + + -- prevent workstation-level settings + DELETE FROM config.workstation_setting_type + WHERE name = 'eg.grid.circ.patron.search'; + END IF; -- insert_on_deploy END $INSERT$; -- 2.11.0