LP#1864507 follow-up, stamp upgrade script, and release notes
authorJane Sandberg <js7389@princeton.edu>
Thu, 27 Oct 2022 22:03:23 +0000 (15:03 -0700)
committerJane Sandberg <js7389@princeton.edu>
Thu, 27 Oct 2022 22:04:30 +0000 (15:04 -0700)
Signed-off-by: Jane Sandberg <sandbergja@gmail.com>

Open-ILS/src/sql/Pg/002.schema.config.sql
Open-ILS/src/sql/Pg/t/lp1308090-facet_punct.pg
Open-ILS/src/sql/Pg/upgrade/1344.function.trim_trailing_punct-improvement.sql [moved from Open-ILS/src/sql/Pg/upgrade/XXXX.function.trim_trailing_punct-improvement.sql with 97% similarity]
docs/RELEASE_NOTES_NEXT/OPAC/marcxml_fields_punctuation.adoc [new file with mode: 0644]

index 68a2956..b3ebef8 100644 (file)
@@ -92,7 +92,7 @@ CREATE TRIGGER no_overlapping_deps
     BEFORE INSERT OR UPDATE ON config.db_patch_dependencies
     FOR EACH ROW EXECUTE PROCEDURE evergreen.array_overlap_check ('deprecates');
 
-INSERT INTO config.upgrade_log (version, applied_to) VALUES ('1343', :eg_version); -- khuckins/christine-burns/mmorgan
+INSERT INTO config.upgrade_log (version, applied_to) VALUES ('1343', :eg_version); -- mrylander/jweston/sandbergja
 
 CREATE TABLE config.bib_source (
        id              SERIAL  PRIMARY KEY,
index d68eaf2..f903003 100644 (file)
@@ -1,6 +1,6 @@
 BEGIN;
 
-SELECT plan(12);
+SELECT plan(18);
 
 SELECT can('metabib', ARRAY['trim_trailing_punctuation'], 'metabib.trim_trailing_punctuation function exists');
 
@@ -1,6 +1,6 @@
 BEGIN;
 
-SELECT evergreen.upgrade_deps_block_check('XXXX', :eg_version);
+SELECT evergreen.upgrade_deps_block_check('1344', :eg_version);
 
 -- This function is used to help clean up facet labels. Due to quirks in
 -- MARC parsing, some facet labels may be generated with periods or commas
diff --git a/docs/RELEASE_NOTES_NEXT/OPAC/marcxml_fields_punctuation.adoc b/docs/RELEASE_NOTES_NEXT/OPAC/marcxml_fields_punctuation.adoc
new file mode 100644 (file)
index 0000000..56005d8
--- /dev/null
@@ -0,0 +1,10 @@
+== Additional trailing punctuation removed from certain fields ==
+
+MarcXML facet, display, and browse fields will undergo some extra
+cleanup before displaying to a user.  Of particular note for any
+title fields that match these criteria, ending `/`, `:`, `;`, and
+`=` will be removed.
+
+This change does not affect MODS fields.  You can check if a
+particular field uses MarcXML or MODS in Server Administration
+-> MARC Search/Facet Fields by consulting the Format column.
\ No newline at end of file