@@ -, +, @@ use Yes/No instead of 0/1 --- .../bug_23716_update_sort_mappings.perl | 6 ++++++ .../admin/searchengine/elasticsearch/mappings.tt | 22 +++++++++------------- 2 files changed, 15 insertions(+), 13 deletions(-) create mode 100644 installer/data/mysql/atomicupdate/bug_23716_update_sort_mappings.perl --- a/installer/data/mysql/atomicupdate/bug_23716_update_sort_mappings.perl +++ a/installer/data/mysql/atomicupdate/bug_23716_update_sort_mappings.perl @@ -0,0 +1,6 @@ +$DBversion = 'XXX'; +if( CheckVersion( $DBversion ) ) { + $dbh->do( "UPDATE search_marc_to_field SET sort = 1 WHERE sort IS NULL" ); + $dbh->do( "ALTER TABLE search_marc_to_field MODIFY COLUMN sort tinyint(1) DEFAULT 1 NOT NULL COMMENT 'Sort defaults to 1 (Yes) and creates sort fields in the index, 0 (no) will prevent this'" ); + NewVersion( $DBversion, 27316, "Description"); +} --- a/koha-tmpl/intranet-tmpl/prog/en/modules/admin/searchengine/elasticsearch/mappings.tt +++ a/koha-tmpl/intranet-tmpl/prog/en/modules/admin/searchengine/elasticsearch/mappings.tt @@ -306,7 +306,11 @@ a.add, a.delete { [% mapping.search_field_label | html %] - [% IF mapping.sort == 'undef' %]Undef[% ELSE %][% mapping.sort | html %][% END %] + [% IF mapping.sort == 0 %] + No + [% ELSE %] + Yes + [% END %] [% IF mapping.facet == 1 %]Yes[% ELSE %]No[% END %] @@ -330,20 +334,12 @@ a.add, a.delete { --