From 699af78be0484b25de9ecb58f6118b9f2985bf3a Mon Sep 17 00:00:00 2001 From: Emily Lamancusa Date: Tue, 17 Dec 2024 16:05:07 -0500 Subject: [PATCH] Bug 38735: Add preferred_name to default search fields for new installations To test: 1. Attach patch first, and then start up KTD or sandbox to see the behavior for a new installation 2. Go to Administration > System Preferences and search for DefaultPatronSearchFields 3. Click to edit --> Confirm preferred_name is checked in the modal that displays 4. Edit a patron to give them a preferred name that is different from their first name 5. Search for the patron by the newly set preferred_name --> Confirm the patron correctly autocompletes and appears in the search results Signed-off-by: David Nind --- installer/data/mysql/mandatory/sysprefs.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/installer/data/mysql/mandatory/sysprefs.sql b/installer/data/mysql/mandatory/sysprefs.sql index f49557be9c..ede2d4d275 100644 --- a/installer/data/mysql/mandatory/sysprefs.sql +++ b/installer/data/mysql/mandatory/sysprefs.sql @@ -206,7 +206,7 @@ INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` ('DefaultLongOverduePatronCategories', '', NULL, "Set the patron categories that will be listed when longoverdue cronjob is executed", 'choice'), ('DefaultLongOverdueSkipLostStatuses', '', NULL, 'Skip these lost statuses by default in longoverdue.pl', 'Free'), ('DefaultLongOverdueSkipPatronCategories', '', NULL, "Set the patron categories that will not be listed when longoverdue cronjob is executed", 'choice'), -('DefaultPatronSearchFields', 'firstname|middle_name|surname|othernames|cardnumber|userid',NULL,'Pipe separated list defining the default fields to be used during a patron search using the "standard" option. If empty Koha will default to "firstname|surname|othernames|cardnumber|userid". Additional fields added to this preference will be added as search options in the dropdown menu on the patron search page.','free'), +('DefaultPatronSearchFields', 'firstname|preferred_name|middle_name|surname|othernames|cardnumber|userid',NULL,'Pipe separated list defining the default fields to be used during a patron search using the "standard" option. If empty Koha will default to "firstname|surname|othernames|cardnumber|userid". Additional fields added to this preference will be added as search options in the dropdown menu on the patron search page.','free'), ('DefaultPatronSearchMethod','starts_with','Choose which search method to use by default when searching with PatronAutoComplete','starts_with|contains','Choice'), ('DefaultSaveRecordFileID','biblionumber','biblionumber|controlnumber','Defines whether the advanced cataloging editor will use the bibliographic record number or control number field to populate the name of the save file','Choice'), ('defaultSortField','relevance','relevance|popularity|call_number|pubdate|acqdate|title|author','Specify the default field used for sorting','Choice'), -- 2.39.5