1 -- Evergreen DB patch XXXX.lp790329_staff_opac_lasso_counts.sql
3 -- Staff record copy counts also triggered an SQL error for org lassos
8 -- check whether patch can be applied
9 SELECT evergreen.upgrade_deps_block_check('0604', :eg_version);
11 CREATE OR REPLACE FUNCTION asset.staff_lasso_record_copy_count (i_lasso INT, rid BIGINT) RETURNS TABLE (depth INT, org_unit INT, visible BIGINT, available BIGINT, unshadow BIGINT, transcendant INT) AS $f$
16 SELECT 1 INTO trans FROM biblio.record_entry b JOIN config.bib_source src ON (b.source = src.id) WHERE src.transcendant AND b.id = rid;
18 FOR ans IN SELECT u.org_unit AS id FROM actor.org_lasso_map AS u WHERE lasso = i_lasso LOOP
23 SUM( CASE WHEN cp.status IN (0,7,12) THEN 1 ELSE 0 END ),
27 actor.org_unit_descendants(ans.id) d
28 JOIN asset.copy cp ON (cp.circ_lib = d.id AND NOT cp.deleted)
29 JOIN asset.call_number cn ON (cn.record = rid AND cn.id = cp.call_number AND NOT cn.deleted)
33 RETURN QUERY SELECT -1, ans.id, 0::BIGINT, 0::BIGINT, 0::BIGINT, trans;