From b7ab7079bbbcce157f4149d7a768d9fe26616f82 Mon Sep 17 00:00:00 2001 From: Michele Morgan Date: Wed, 12 Oct 2022 16:40:21 -0400 Subject: [PATCH] LP1838553 User Display Name Add preferred names to 'User Alias or Display Name' Signed-off-by: Michele Morgan --- .../OpenILS/Application/Storage/Publisher/action.pm | 10 +++++----- 1 file changed, 5 insertions(+), 5 deletions(-) diff --git a/Open-ILS/src/perlmods/lib/OpenILS/Application/Storage/Publisher/action.pm b/Open-ILS/src/perlmods/lib/OpenILS/Application/Storage/Publisher/action.pm index 88e80b57d2..9a6c302904 100644 --- a/Open-ILS/src/perlmods/lib/OpenILS/Application/Storage/Publisher/action.pm +++ b/Open-ILS/src/perlmods/lib/OpenILS/Application/Storage/Publisher/action.pm @@ -2270,12 +2270,12 @@ SELECT h.id, h.request_time, h.capture_time, h.fulfillment_time, h.checkin_time u.alias ELSE REGEXP_REPLACE(ARRAY_TO_STRING(ARRAY[ - COALESCE(u.family_name, ''), - COALESCE(u.suffix, ''), + COALESCE(u.pref_family_name, u.family_name, ''), + COALESCE(u.pref_suffix, u.suffix, ''), ', ', - COALESCE(u.prefix, ''), - COALESCE(u.first_given_name, ''), - COALESCE(u.second_given_name, '') + COALESCE(u.pref_prefix, u.prefix, ''), + COALESCE(u.pref_first_given_name, u.first_given_name, ''), + COALESCE(u.pref_second_given_name, u.second_given_name, '') ], ' '), E'\\s+,', ',') END AS usr_alias_or_display_name, -- 2.43.2