From a68091ee14be05aba9e9cde781e6008e1ed2df61 Mon Sep 17 00:00:00 2001 From: Bill Erickson Date: Thu, 24 Sep 2020 11:46:58 -0400 Subject: [PATCH] LP1896840 Publisher display includes 264 tag The stock Publisher display field now extracts data from 260 OR 264 tags, whichever has a value first. Release notes included with upgrade instructions. Signed-off-by: Bill Erickson Signed-off-by: Garry Collum Signed-off-by: Jane Sandberg --- Open-ILS/src/sql/Pg/950.data.seed-values.sql | 2 +- .../Pg/upgrade/XXXX.data.publisher-264.sql | 9 +++++++ .../Cataloging/publisher-display-264.adoc | 24 +++++++++++++++++++ 3 files changed, 34 insertions(+), 1 deletion(-) create mode 100644 Open-ILS/src/sql/Pg/upgrade/XXXX.data.publisher-264.sql create mode 100644 docs/RELEASE_NOTES_NEXT/Cataloging/publisher-display-264.adoc diff --git a/Open-ILS/src/sql/Pg/950.data.seed-values.sql b/Open-ILS/src/sql/Pg/950.data.seed-values.sql index a23f217dfb..c694c9ad84 100644 --- a/Open-ILS/src/sql/Pg/950.data.seed-values.sql +++ b/Open-ILS/src/sql/Pg/950.data.seed-values.sql @@ -323,7 +323,7 @@ INSERT INTO config.metabib_field (id, field_class, name, format, VALUES ( 52, 'identifier', 'origin_info', 'marcxml', oils_i18n_gettext(52, 'Origin Info', 'cmf', 'label'), - $$//*[@tag='260']$$, + $$//*[@tag='260' or @tag='264'][1]$$, $$//*[local-name()='subfield' and contains('abc',@code)]$$, TRUE, FALSE, FALSE ); diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.data.publisher-264.sql b/Open-ILS/src/sql/Pg/upgrade/XXXX.data.publisher-264.sql new file mode 100644 index 0000000000..1607c1325d --- /dev/null +++ b/Open-ILS/src/sql/Pg/upgrade/XXXX.data.publisher-264.sql @@ -0,0 +1,9 @@ +BEGIN; + +-- SELECT evergreen.upgrade_deps_block_check('TODO', :eg_version); + +UPDATE config.metabib_field +SET xpath = '//*[@tag=''260'' or @tag=''264''][1]' +WHERE id = 52 AND xpath = '//*[@tag=''260'']'; + +COMMIT; diff --git a/docs/RELEASE_NOTES_NEXT/Cataloging/publisher-display-264.adoc b/docs/RELEASE_NOTES_NEXT/Cataloging/publisher-display-264.adoc new file mode 100644 index 0000000000..2c07d842ec --- /dev/null +++ b/docs/RELEASE_NOTES_NEXT/Cataloging/publisher-display-264.adoc @@ -0,0 +1,24 @@ +Publisher Catalog Display Includes 264 Tag +^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ + +Publisher values are now extracted for dislpay from tags 260 OR 264. + +Upgrade Notes ++++++++++++++ + +A partial reingest is required to extract the new publisher data for display. +This query may be long-running. + +[source,sql] +-------------------------------------------------------------------------- +WITH affected_bibs AS ( + SELECT DISTINCT(bre.id) AS id + FROM biblio.record_entry bre + JOIN metabib.real_full_rec mrfr + ON (mrfr.record = bre.id AND mrfr.tag = '264') + WHERE NOT bre.deleted +) +SELECT metabib.reingest_metabib_field_entries(id, TRUE, FALSE, TRUE, TRUE) +FROM affected_bibs; +-------------------------------------------------------------------------- + -- 2.43.2