]> git.evergreen-ils.org Git - working/Evergreen.git/commit
LP#1501781 - Make patron name search diacritic/space insensitive.
authorDan Pearl <dpearl@cwmars.org>
Thu, 1 Oct 2015 13:49:17 +0000 (09:49 -0400)
committerJason Stephenson <jason@sigio.com>
Thu, 17 Mar 2016 21:54:27 +0000 (17:54 -0400)
commitaa0805e15ac33b1d1da1d6c464ccc5a5e80c1e04
tree38478064813264d6e7919cdbc7af7c3220022162
parent3559cd95e1bdc4012c05919e586e3b78eb23d8c8
LP#1501781 - Make patron name search diacritic/space insensitive.

Diacritical marks may exist in the patron record, as they should, but
this makes patron name search difficult for librarians who may be
unfamiliar with all the special characters used and also how to elicit
them from a keyboard.  To ease this, accented characters will be
converted into their 'plain' analogs for comparison purposes.

So, for example, if the patron's last name is Chávez, typing "Chavez"
in the Last Name box in Patron Search will match it.

Spaces in a name (like "De la Croix") will be squashed out so that
name would be matched by "Delacroix" or "De la Croix" or variants.

The librarian can enter the accented characters or not.

Signed-off-by: Dan Pearl <dpearl@cwmars.org>
Signed-off-by: Jason Stephenson <jason@sigio.com>
Open-ILS/src/sql/Pg/000.functions.general.sql
Open-ILS/src/sql/Pg/005.schema.actors.sql
Open-ILS/src/sql/Pg/950.data.seed-values.sql
Open-ILS/src/sql/Pg/create_database_extensions.sql
Open-ILS/src/sql/Pg/upgrade/XXXX.schema.patron_unaccent.sql [new file with mode: 0644]
docs/RELEASE_NOTES_NEXT/Client/accent_insensitive_patron_search [new file with mode: 0644]