From fa363a9d3917a7f6dba48cf5c91e125decd6d8d9 Mon Sep 17 00:00:00 2001 From: Bill Erickson Date: Sun, 28 Oct 2018 10:10:12 -0400 Subject: [PATCH] LP#1714070 Parent/guardian field release notes Signed-off-by: Bill Erickson Signed-off-by: Kathy Lussier Signed-off-by: Jason Etheridge --- .../Circulation/patron-guardian-field.adoc | 52 +++++++++++++++++++ 1 file changed, 52 insertions(+) create mode 100644 docs/RELEASE_NOTES_NEXT/Circulation/patron-guardian-field.adoc diff --git a/docs/RELEASE_NOTES_NEXT/Circulation/patron-guardian-field.adoc b/docs/RELEASE_NOTES_NEXT/Circulation/patron-guardian-field.adoc new file mode 100644 index 0000000000..c629214c64 --- /dev/null +++ b/docs/RELEASE_NOTES_NEXT/Circulation/patron-guardian-field.adoc @@ -0,0 +1,52 @@ +Patron Parent/Guardian Field +^^^^^^^^^^^^^^^^^^^^^^^^^^^^ + +Patrons now have a new dedicated parent/guardian field. This field is +editable in the patron edit interface, displays in the patron +summary side bar on the browser client, and is search-able from the +patron search interface in the browser client. + +Patron Editor ++++++++++++++ + +In addition to the standard "show" and "suggest" visibility settings, +the new guardian field comes with a library setting +'ui.patron.edit.guardian_required_for_juv' ("GUI: Juvenile account +requires parent/guardian"). When this setting is applied, a value +will be required in the patron editor when the juvenile flag is active. + +Upgrade Notes ++++++++++++++ + +Sites who traditionally store parent/guardian information in the +patron 'Secondary Identification' field can migrate values from this +field to the new guardian field with the following SQL: + +[source,sql] +------------------------------------------------------------------------- +BEGIN; + +-- 1. Find the local ID of the parent/guardian identification type + +SELECT * FROM config.identification_type; + +-- 2. On my test system, the id is "101". It will vary!. +-- Migrate the value from the ident2 field to the guardian field. + +UPDATE actor.usr + SET guardian = ident_value2 +WHERE + ident_type2 = 101 -- !! CHANGE TO SUIT + AND ident_value2 IS NOT NULL + AND ident_value2 <> ''; + +-- 3. delete the original secondary identification data + +UPDATE actor.usr + SET ident_value2 = NULL, ident_type2 = NULL +WHERE + ident_type2 = 101; -- !! CHANGE TO SUIT + +COMMIT; +------------------------------------------------------------------------- + -- 2.43.2