From f3bdc3d12df98bfd59052b8478d6101add44e2aa Mon Sep 17 00:00:00 2001 From: Galen Charlton Date: Mon, 27 Jul 2020 10:51:37 -0400 Subject: [PATCH] LP#1802166: (follow-up) document a way to clear names from already-purged patron records For reference, the following SQL will clear the preferred name and name keyword fields from already-purged records: UPDATE actor.usr SET pref_prefix = NULL, pref_first_given_name = NULL, pref_second_given_name = NULL, pref_family_name = NULL, pref_suffix = NULL, name_keywords = NULL WHERE usrname ~ ('^' || id || '-PURGED') AND NOT active AND deleted AND ( pref_prefix IS NOT NULL OR pref_first_given_name IS NOT NULL OR pref_second_given_name IS NOT NULL OR pref_family_name IS NOT NULL OR pref_suffix IS NOT NULL OR name_keywords IS NOT NULL ); Signed-off-by: Galen Charlton --- .../Circulation/purge_usr_pref_names.adoc | 25 ++++++++++++++++++++++ 1 file changed, 25 insertions(+) diff --git a/docs/RELEASE_NOTES_NEXT/Circulation/purge_usr_pref_names.adoc b/docs/RELEASE_NOTES_NEXT/Circulation/purge_usr_pref_names.adoc index bb3eb22e26..6f16aaaeb4 100644 --- a/docs/RELEASE_NOTES_NEXT/Circulation/purge_usr_pref_names.adoc +++ b/docs/RELEASE_NOTES_NEXT/Circulation/purge_usr_pref_names.adoc @@ -3,3 +3,28 @@ Purge User Preferred Names The new, user preferred name fields are now set to NULL in the database when a user account is purged via the staff client or using the actor.usr_delete function in the database. + +To clear the preferred name fields from records that have already been +purged, run the following SQL update: + +[source,sql] +---- +UPDATE actor.usr +SET pref_prefix = NULL, + pref_first_given_name = NULL, + pref_second_given_name = NULL, + pref_family_name = NULL, + pref_suffix = NULL, + name_keywords = NULL +WHERE usrname ~ ('^' || id || '-PURGED') +AND NOT active +AND deleted +AND ( + pref_prefix IS NOT NULL OR + pref_first_given_name IS NOT NULL OR + pref_second_given_name IS NOT NULL OR + pref_family_name IS NOT NULL OR + pref_suffix IS NOT NULL OR + name_keywords IS NOT NULL +); +---- -- 2.11.0