From 70df87ddff3d0b4b2072c9964df3773b80ee0a13 Mon Sep 17 00:00:00 2001 From: Janusz Kaczmarek Date: Wed, 25 Oct 2023 09:05:24 +0000 Subject: [PATCH] Bug 32707: Add 'ESPreventAutoTruncate' preference This patch adds a new 'ESPreventAutoTruncate' preference allowing to define Elasticsearch search fields that should not be autotruncated when 'QueryAutoTruncate' is active (e.g. barcode). Signed-off-by: Victor Grousset/tuxayo Signed-off-by: Nick Clemens --- installer/data/mysql/atomicupdate/bug_32707.pl | 16 ++++++++++++++++ installer/data/mysql/mandatory/sysprefs.sql | 1 + .../en/modules/admin/preferences/searching.pref | 5 +++++ 3 files changed, 22 insertions(+) create mode 100755 installer/data/mysql/atomicupdate/bug_32707.pl diff --git a/installer/data/mysql/atomicupdate/bug_32707.pl b/installer/data/mysql/atomicupdate/bug_32707.pl new file mode 100755 index 00000000000..ca09bc8578a --- /dev/null +++ b/installer/data/mysql/atomicupdate/bug_32707.pl @@ -0,0 +1,16 @@ +use Modern::Perl; + +return { + bug_number => "32707", + description => "Add `ESPreventAutoTruncate` preference", + up => sub { + my ($args) = @_; + my ( $dbh, $out ) = @$args{qw(dbh out)}; + $dbh->do( + q{ + INSERT IGNORE INTO systempreferences ( `variable`, `value`, `options`, `explanation`, `type` ) + VALUES ('ESPreventAutoTruncate', 'barcode|control-number|control-number-identifier|date-of-acquisition|date-of-publication|date-time-last-modified|identifier-standard|isbn|issn|itype|lc-card-number|number-local-acquisition|other-control-number|record-control-number', NULL, 'List of searchfields (separated by | or ,) that should not be autotruncated by Elasticsearch even if QueryAutoTruncate is set to Yes', 'Free') + } + ); + }, +}; diff --git a/installer/data/mysql/mandatory/sysprefs.sql b/installer/data/mysql/mandatory/sysprefs.sql index b1aba01bcbd..e4ce217b320 100644 --- a/installer/data/mysql/mandatory/sysprefs.sql +++ b/installer/data/mysql/mandatory/sysprefs.sql @@ -248,6 +248,7 @@ INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` ('ERMProviderEbscoApiKey', '', '', 'API key for EBSCO', 'free'), ('ERMProviderEbscoCustomerID', '', '', 'Customer ID for EBSCO', 'free'), ('ERMProviders', 'local', 'local|ebsco', 'Set the providers for the ERM module', 'Choice'), +('ESPreventAutoTruncate', 'barcode|control-number|control-number-identifier|date-of-acquisition|date-of-publication|date-time-last-modified|identifier-standard|isbn|issn|itype|lc-card-number|number-local-acquisition|other-control-number|record-control-number', NULL, 'List of searchfields (separated by | or ,) that should not be autotruncated by Elasticsearch even if QueryAutoTruncate is set to Yes', 'free'), ('ExcludeHolidaysFromMaxPickUpDelay', '0', NULL, 'If ON, reserves max pickup delay takes into accountthe closed days.', 'YesNo'), ('expandedSearchOption','0',NULL,'If ON, set advanced search to be expanded by default','YesNo'), ('ExpireReservesAutoFill','0',NULL,'Automatically fill the next hold with a automatically canceled expired waiting hold.','YesNo'), diff --git a/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/searching.pref b/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/searching.pref index 86b9f54ae15..71fe2db333c 100644 --- a/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/searching.pref +++ b/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/searching.pref @@ -8,6 +8,7 @@ Searching: 1: automatically. 0: only if * is added. - "
(The * character would be used like so: Har* or *logging.)" + - NOTE: record identifiers (biblionumber, authid) will never be autotruncated. - - pref: QueryFuzzy type: boolean @@ -94,6 +95,10 @@ Searching: 1: Enable 0: Disable - "the option for staff with permission to create/edit custom saved search filters." + - + - 'List of searchfields (separated by | or ,) that should not be autotruncated by Elasticsearch even if QueryAutoTruncate is set to Yes:' + - pref: ESPreventAutoTruncate + class: long Search form: - - pref: LoadSearchHistoryToTheFirstLoggedUser -- 2.30.2