Report Copy Status by circ lib evergreen

copy status by circ lib.sql

-- List counts of copy statuses by circ lib
select aou.shortname,cs.name as status,count(ac.id),now()
from asset.copy ac
join config.copy_status cs on (ac.status=cs.id) 
join actor.org_unit aou on aou.id=ac.circ_lib
where ac.deleted=false
-- and ac.circ_lib in (SELECT id FROM actor.org_unit_descendants(127))
group by aou.shortname,cs.name
order by aou.shortname,cs.name
;

-- list counts of copy statuses by circ lib and circ_mod
select aou.shortname,ac.circ_modifier, cs.name as status,count(ac.id),now()
from asset.copy ac
join config.copy_status cs on (ac.status=cs.id) 
join actor.org_unit aou on aou.id=ac.circ_lib
where ac.deleted=false
-- and ac.circ_lib in (SELECT id FROM actor.org_unit_descendants(127))
group by aou.parent_ou,aou.shortname,ac.circ_modifier,cs.name
order by aou.parent_ou,aou.shortname,ac.circ_modifier,cs.name
;