3 SELECT evergreen.upgrade_deps_block_check('0898', :eg_version);
5 CREATE OR REPLACE FUNCTION unapi.mmr_mra (
11 depth INT DEFAULT NULL,
12 slimit HSTORE DEFAULT NULL,
13 soffset HSTORE DEFAULT NULL,
14 include_xmlns BOOL DEFAULT TRUE,
15 pref_lib INT DEFAULT NULL
20 CASE WHEN $9 THEN 'http://open-ils.org/spec/indexing/v1' ELSE NULL END AS xmlns,
21 'tag:open-ils.org:U2@mmr/' || $1 AS metarecord
26 WITH aou AS (SELECT COALESCE(id, (evergreen.org_top()).id) AS id
27 FROM actor.org_unit WHERE shortname = $5 LIMIT 1)
29 FROM metabib.metarecord_source_map, aou
30 WHERE metarecord = $1 AND (
32 SELECT 1 FROM asset.opac_visible_copies
33 WHERE record = source AND circ_lib IN (
34 SELECT id FROM actor.org_unit_descendants(aou.id, $6))
37 OR EXISTS (SELECT 1 FROM located_uris(source, aou.id, $10) LIMIT 1)
45 cmra.value AS "coded-value",
55 SELECT DISTINCT aid, attr, value
57 SELECT v.source AS id,
61 FROM metabib.record_attr_vector_list v
62 JOIN config.coded_value_map c ON ( c.id = ANY( v.vlist ) )
64 JOIN sourcelist ON (x.id = sourcelist.source)
66 JOIN config.record_attr_definition rad ON (cmra.attr = rad.name)
81 SELECT DISTINCT aid, attr, value
83 SELECT v.source AS id,
87 FROM metabib.record_attr_vector_list v
88 JOIN metabib.uncontrolled_record_attr_value m ON ( m.id = ANY( v.vlist ) )
90 JOIN sourcelist ON (x.id = sourcelist.source)
92 JOIN config.record_attr_definition rad ON (umra.attr = rad.name)
98 $F$ LANGUAGE SQL STABLE;