1 Patron Parent/Guardian Field
2 ^^^^^^^^^^^^^^^^^^^^^^^^^^^^
4 Patrons now have a new dedicated parent/guardian field. This field is
5 editable in the patron edit interface, displays in the patron
6 summary side bar on the browser client, and is search-able from the
7 patron search interface in the browser client.
12 In addition to the standard "show" and "suggest" visibility settings,
13 the new guardian field comes with a library setting
14 'ui.patron.edit.guardian_required_for_juv' ("GUI: Juvenile account
15 requires parent/guardian"). When this setting is applied, a value
16 will be required in the patron editor when the juvenile flag is active.
21 Sites who traditionally store parent/guardian information in the
22 patron 'Secondary Identification' field can migrate values from this
23 field to the new guardian field with the following SQL:
26 -------------------------------------------------------------------------
29 -- 1. Find the local ID of the parent/guardian identification type
31 SELECT * FROM config.identification_type;
33 -- 2. On my test system, the id is "101". It will vary!.
34 -- Migrate the value from the ident2 field to the guardian field.
37 SET guardian = ident_value2
39 ident_type2 = 101 -- !! CHANGE TO SUIT
40 AND ident_value2 IS NOT NULL
41 AND ident_value2 <> '';
43 -- 3. delete the original secondary identification data
46 SET ident_value2 = NULL, ident_type2 = NULL
48 ident_type2 = 101; -- !! CHANGE TO SUIT
51 -------------------------------------------------------------------------