3 SELECT evergreen.upgrade_deps_block_check('0877', :eg_version);
5 -- Don't use Series search field as the browse field
6 UPDATE config.metabib_field SET
9 browse_sort_xpath = NULL,
10 xpath = $$//mods32:mods/mods32:relatedItem[@type="series"]/mods32:titleInfo[not(@type="nfi")]$$
13 -- Create a new series browse config
14 INSERT INTO config.metabib_field ( id, field_class, name, label, format, xpath, search_field, authority_xpath, browse_field, browse_sort_xpath ) VALUES
15 (32, 'series', 'browse', oils_i18n_gettext(32, 'Series Title (Browse)', 'cmf', 'label'), 'mods32', $$//mods32:mods/mods32:relatedItem[@type="series"]/mods32:titleInfo[@type="nfi"]$$, FALSE, '//@xlink:href', TRUE, $$*[local-name() != "nonSort"]$$ );
19 \qecho This is a full field-entry reingest of your bib records.
20 \qecho It will take a while.
21 \qecho You may cancel now without losing the effect of the rest of the
22 \qecho upgrade script, and arrange the reingest later.
24 SELECT COUNT(metabib.reingest_metabib_field_entries(id))
25 FROM biblio.record_entry WHERE deleted IS FALSE;