1 -- Evergreen DB patch 0569.schema.unapi-auri-fix.sql
7 -- check whether patch can be applied
8 SELECT evergreen.upgrade_deps_block_check('0569', :eg_version);
10 CREATE OR REPLACE FUNCTION unapi.auri ( obj_id BIGINT, format TEXT, ename TEXT, includes TEXT[], org TEXT, depth INT DEFAULT NULL, slimit INT DEFAULT NULL, soffset INT DEFAULT NULL, include_xmlns BOOL DEFAULT TRUE ) RETURNS XML AS $F$
14 CASE WHEN $9 THEN 'http://open-ils.org/spec/holdings/v1' ELSE NULL END AS xmlns,
15 'tag:open-ils.org:U2@auri/' || uri.id AS id,
20 XMLELEMENT( name copies,
22 WHEN ('acn' = ANY ($4)) THEN
23 (SELECT XMLAGG(acn) FROM (SELECT unapi.acn( call_number, 'xml', 'copy', evergreen.array_remove_item_by_value($4,'auri'), $5, $6, $7, $8, FALSE) FROM asset.uri_call_number_map WHERE uri = uri.id)x)
30 GROUP BY uri.id, use_restriction, href, label;