Normalize ISBNs by stripping hyphens in search methods and in reporter.materialized_s...
authordbs <dbs@dcc99617-32d9-48b4-a31d-7c20da2025e4>
Fri, 11 Feb 2011 21:57:51 +0000 (21:57 +0000)
committerdbs <dbs@dcc99617-32d9-48b4-a31d-7c20da2025e4>
Fri, 11 Feb 2011 21:57:51 +0000 (21:57 +0000)
commitbec317050cb6662a79cd0ff6a76ebabec81cc93d
treef688f4893a6127037379c85981c6c11dfa560fec
parentb99e41f77fcbec68687a096dc32a768ab72069dc
Normalize ISBNs by stripping hyphens in search methods and in reporter.materialized_simple_record

We weren't normalizing ISBNs in search or in reporter.materialized_simple_record
which required users to exactly match the form of the ISBN as entered in the
MARC record to get a successful search result - pretty hit or miss.

The longer term fix in 2.0 and above is to make the ISBN search search against
the identifier|isbn index, which also gets ISBN10/ISBN13 equivalence goodness.
But this patch will be relatively easy to backport through to 1.6.1 and plugs
some of the holes in our exposed APIs and search points in the short term.

git-svn-id: svn://svn.open-ils.org/ILS/branches/rel_1_6@19436 dcc99617-32d9-48b4-a31d-7c20da2025e4
Open-ILS/src/perlmods/OpenILS/Application/Search/Biblio.pm
Open-ILS/src/sql/Pg/reporter-schema.sql
Open-ILS/src/sql/Pg/upgrade/0485.schema.reporter_strip_isbns.sql [new file with mode: 0644]