1 -- Evergreen DB patch XXXX.fix_author_other_index.sql
3 -- Fix author|other index so that it doesn't exclude 700
4 -- fields that contain relator values in the $e or $4.
8 -- check whether patch can be applied
9 SELECT evergreen.upgrade_deps_block_check('0599', :eg_version);
11 UPDATE config.metabib_field
12 SET xpath = $$//mods32:mods/mods32:name[@type='personal' and not(mods32:role/mods32:roleTerm[text()='creator'])]$$
13 WHERE field_class = 'author'
15 AND xpath = $$//mods32:mods/mods32:name[@type='personal' and not(mods32:role)]$$
16 AND format = 'mods32';
18 -- To reindex the affected bibs, you can run something like this:
20 -- SELECT metabib.reingest_metabib_field_entries(record)
22 -- SELECT DISTINCT record
23 -- FROM metabib.real_full_rec
24 -- WHERE tag IN ('600', '700', '720', '800')
25 -- AND subfield IN ('4', 'e')