LP#1553287: Add part information to biblio.fingerprint
authorKathy Lussier <klussier@masslnc.org>
Wed, 22 Jun 2016 17:59:34 +0000 (13:59 -0400)
committerMike Rylander <mrylander@gmail.com>
Thu, 16 Feb 2017 14:59:25 +0000 (09:59 -0500)
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 <klussier@masslnc.org>
Signed-off-by: Mike Rylander <mrylander@gmail.com>
Open-ILS/src/sql/Pg/002.schema.config.sql
Open-ILS/src/sql/Pg/upgrade/XXXX.data.add_parts_for_biblio_fingerprint.sql [new file with mode: 0644]
docs/RELEASE_NOTES_NEXT/Administration/add-parts-to-biblio-fingerprint.adoc [new file with mode: 0644]

index bb14f6c..9669a87 100644 (file)
@@ -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 (file)
index 0000000..37b2b31
--- /dev/null
@@ -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 (file)
index 0000000..3d872ea
--- /dev/null
@@ -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.
+
+