OPAC Browse: Build browse entry sort_value column separately from value
authorLebbeous Fogle-Weekley <lebbeous@esilibrary.com>
Tue, 21 May 2013 20:48:48 +0000 (16:48 -0400)
committerLebbeous Fogle-Weekley <lebbeous@esilibrary.com>
Tue, 21 May 2013 20:48:48 +0000 (16:48 -0400)
commit8843a15bbeb6eaf9c9749be09e0e39811d472179
tree7d2247072ab64bf63bb24990d477d4e97d83efd0
parentfbb738a2ac62b3eb9b40d758612c2ac99ae7131c
OPAC Browse: Build browse entry sort_value column separately from value

This means changes to the ingest process and a config.metabib_field
table that's one column wider.

This means you can get browse headings like "The Nutcracker" that appear
visually as such, but sort as if they only contained "Nutcracker",
assuming correct cataloging with non-filing indicators.

Previously the heading would both look and sort like "Nutcracker."

Signed-off-by: Lebbeous Fogle-Weekley <lebbeous@esilibrary.com>
Open-ILS/src/sql/Pg/002.schema.config.sql
Open-ILS/src/sql/Pg/030.schema.metabib.sql
Open-ILS/src/sql/Pg/950.data.seed-values.sql
Open-ILS/src/sql/Pg/upgrade/YYYY.schema.bib-auth-browse.sql