From 0a157cdab2390fef60082638e9592e340865995a Mon Sep 17 00:00:00 2001 From: Jane Sandberg Date: Tue, 11 Aug 2020 13:10:44 -0700 Subject: [PATCH] Docs: tweaks to 3.4.4 release notes Signed-off-by: Jane Sandberg --- docs/RELEASE_NOTES_3_4.adoc | 32 +++++++++++++++++++++++++++++++- 1 file changed, 31 insertions(+), 1 deletion(-) diff --git a/docs/RELEASE_NOTES_3_4.adoc b/docs/RELEASE_NOTES_3_4.adoc index fd6800e63a..703092d88b 100644 --- a/docs/RELEASE_NOTES_3_4.adoc +++ b/docs/RELEASE_NOTES_3_4.adoc @@ -130,6 +130,37 @@ a2enmod headers sudo /etc/init.d/apache2 restart ---- +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 +); +---- + Acknowledgements ~~~~~~~~~~~~~~~~ We would like to thank the following individuals who contributed code, @@ -161,7 +192,6 @@ testing and documentation patches to the 3.4.4 point release of Evergreen: * Jason Stephenson * Josh Stompro * John Yorio -* John Yorio Evergreen 3.4.3 --------------- -- 2.43.2