From 430e258a48bfee9a4fcb629823b55107dc8f043a Mon Sep 17 00:00:00 2001 From: Kathy Lussier Date: Wed, 22 Jun 2016 13:59:34 -0400 Subject: [PATCH] LP#1553287: Add part information to biblio.fingerprint Evergreen metarecord searching will sometimes group together different works that are part of the same series because biblio.fingerprint doesn't incorporate subfield n or p from the title. For example, bib records for the Mockinjay movies list the Hunger Games in the 245a with Mockinjay in subfield p. Without the part information in the fingerprint, Evergreen will group these movies together with versions of the first Hunger Games book. This branch adds parts subfields to biblio.fingerprint to allow us to distinguish among different parts in a series. Signed-off-by: Kathy Lussier --- Open-ILS/src/sql/Pg/002.schema.config.sql | 14 ++++++++++++++ .../XXXX.data.add_parts_for_biblio_fingerprint.sql | 19 +++++++++++++++++++ .../add-parts-to-biblio-fingerprint.adoc | 9 +++++++++ 3 files changed, 42 insertions(+) create mode 100644 Open-ILS/src/sql/Pg/upgrade/XXXX.data.add_parts_for_biblio_fingerprint.sql create mode 100644 docs/RELEASE_NOTES_NEXT/Administration/add-parts-to-biblio-fingerprint.adoc diff --git a/Open-ILS/src/sql/Pg/002.schema.config.sql b/Open-ILS/src/sql/Pg/002.schema.config.sql index a9a4de19cc..7dc706dbbc 100644 --- a/Open-ILS/src/sql/Pg/002.schema.config.sql +++ b/Open-ILS/src/sql/Pg/002.schema.config.sql @@ -170,6 +170,20 @@ INSERT INTO config.biblio_fingerprint (name, xpath, format, first_word) TRUE ); +INSERT INTO config.biblio_fingerprint (name, xpath, format) + VALUES ( + 'PartName', + '//mods32:mods/mods32:titleInfo/mods32:partName', + 'mods32' + ); + +INSERT INTO config.biblio_fingerprint (name, xpath, format) + VALUES ( + 'PartNumber', + '//mods32:mods/mods32:titleInfo/mods32:partNumber', + 'mods32' + ); + CREATE TABLE config.metabib_class ( name TEXT PRIMARY KEY, label TEXT NOT NULL UNIQUE, diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.data.add_parts_for_biblio_fingerprint.sql b/Open-ILS/src/sql/Pg/upgrade/XXXX.data.add_parts_for_biblio_fingerprint.sql new file mode 100644 index 0000000000..37b2b31aca --- /dev/null +++ b/Open-ILS/src/sql/Pg/upgrade/XXXX.data.add_parts_for_biblio_fingerprint.sql @@ -0,0 +1,19 @@ +BEGIN; + +-- SELECT evergreen.upgrade_deps_block_check('XXXX', :eg_version); + +INSERT INTO config.biblio_fingerprint (name, xpath, format) + VALUES ( + 'PartName', + '//mods32:mods/mods32:titleInfo/mods32:partName', + 'mods32' + ); + +INSERT INTO config.biblio_fingerprint (name, xpath, format) + VALUES ( + 'PartNumber', + '//mods32:mods/mods32:titleInfo/mods32:partNumber', + 'mods32' + ); + +COMMIT; diff --git a/docs/RELEASE_NOTES_NEXT/Administration/add-parts-to-biblio-fingerprint.adoc b/docs/RELEASE_NOTES_NEXT/Administration/add-parts-to-biblio-fingerprint.adoc new file mode 100644 index 0000000000..3d872eafd9 --- /dev/null +++ b/docs/RELEASE_NOTES_NEXT/Administration/add-parts-to-biblio-fingerprint.adoc @@ -0,0 +1,9 @@ +Bibliographic Fingerprint Improvement +^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ +The bibliographic fingerprint will now incorporate subfield n and p from MARC +title fields to better distinguish between records of the same series that +may share the same title but have a different part. With this change, these +MARC records will no longer be grouped together in a 'Group Formats & Editions' +search. + + -- 2.11.0