LP#1501781 - Make patron name search diacritic/space insensitive. user/dpearl/accent2
authorDan Pearl <dpearl@cwmars.org>
Thu, 1 Oct 2015 13:49:17 +0000 (09:49 -0400)
committerDan Pearl <dpearl@cwmars.org>
Tue, 15 Dec 2015 18:19:18 +0000 (13:19 -0500)
commit1194532dca0d70e1cb361fd80149778eacdcdbe1
tree9b1ba4bb9eebc84487d61fb990c091b823db4684
parent2038e93aa68baaabe20a8b4218cfb0ed6fc5903c
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:
Signed-off-by:
Open-ILS/src/perlmods/Build.PL
Open-ILS/src/perlmods/lib/OpenILS/Application/Storage/Publisher/actor.pm
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]