From abbcc13856d1fe71ab51272b59d534c22b467a2a 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 Signed-off-by: Mike Rylander --- Open-ILS/src/sql/Pg/002.schema.config.sql | 14 ++++++++++++++ ....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 bb14f6c2dc..9669a8755a 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.43.2