3 SELECT evergreen.upgrade_deps_block_check('0892', :eg_version);
5 CREATE OR REPLACE VIEW metabib.record_attr_flat AS
9 FROM metabib.record_attr_vector_list v
10 LEFT JOIN metabib.uncontrolled_record_attr_value m ON ( m.id = ANY( v.vlist ) )
12 SELECT v.source AS id,
15 FROM metabib.record_attr_vector_list v
16 LEFT JOIN config.coded_value_map c ON ( c.id = ANY( v.vlist ) );
18 CREATE OR REPLACE FUNCTION unapi.mmr_mra (
24 depth INT DEFAULT NULL,
25 slimit HSTORE DEFAULT NULL,
26 soffset HSTORE DEFAULT NULL,
27 include_xmlns BOOL DEFAULT TRUE,
28 pref_lib INT DEFAULT NULL
33 CASE WHEN $9 THEN 'http://open-ils.org/spec/indexing/v1' ELSE NULL END AS xmlns,
34 'tag:open-ils.org:U2@mmr/' || $1 AS metarecord
39 WITH aou AS (SELECT COALESCE(id, (evergreen.org_top()).id) AS id
40 FROM actor.org_unit WHERE shortname = $5 LIMIT 1)
42 FROM metabib.metarecord_source_map, aou
43 WHERE metarecord = $1 AND (
45 SELECT 1 FROM asset.opac_visible_copies
46 WHERE record = source AND circ_lib IN (
47 SELECT id FROM actor.org_unit_descendants(aou.id, $6))
50 OR EXISTS (SELECT 1 FROM located_uris(source, aou.id, $10) LIMIT 1)
58 cmra.value AS "coded-value",
68 SELECT v.source AS id,
72 FROM metabib.record_attr_vector_list v
73 JOIN config.coded_value_map c ON ( c.id = ANY( v.vlist ) )
75 JOIN config.record_attr_definition rad ON (cmra.attr = rad.name)
76 JOIN sourcelist ON (cmra.id = sourcelist.source)
91 SELECT v.source AS id,
95 FROM metabib.record_attr_vector_list v
96 JOIN metabib.uncontrolled_record_attr_value m ON ( m.id = ANY( v.vlist ) )
98 JOIN config.record_attr_definition rad ON (umra.attr = rad.name)
99 JOIN sourcelist ON (umra.id = sourcelist.source)
105 $F$ LANGUAGE SQL STABLE;