1 Preloaded Audio Icon and Search Format
2 ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
3 A new search and icon format called Preloaded Audio now exists
4 that overlaps with the eAudio format. If you want to exclude
5 the Preloaded Audio format from overlapping with eAudio
6 you can use the following SQL:
8 UPDATE config.composite_attr_entry_definition SET definition = '{"0":{"_attr":"item_type","_val":"i"},"1":[{"_attr":"item_form","_val":"o"},{"_attr":"item_form","_val":"s"}]}'
9 WHERE coded_value IN (SELECT id FROM config.coded_value_map WHERE code = 'eaudio');
11 It is also recommended that you reingest your bibliographic records
12 to updated the fixed field indexes. You can accomplish this by running
13 the following query in your database:
15 SELECT metabib.reingest_record_attributes(source)
16 FROM metabib.record_attr_vector_list WHERE
17 (SELECT id FROM config.coded_value_map WHERE ctype = 'item_form' AND code = 'q') = ANY(vlist)
18 AND (SELECT id FROM config.coded_value_map WHERE ctype = 'item_type' AND code = 'i') = ANY(vlist);