Simple Report of Items by Status / Easily Adaptable

-- report of items by status
-- 14 is damaged
-- select * from config.copy_status; to see more

-- this can be easily adapted to see other information such as reports by call number, etc...


select aou.shortname AS "Branch", ac.barcode AS "Barcode", acn.label AS "Call Number", acl.name AS "Copy Location", rmsr.title AS "Title", rmsr.author AS "Author"
from asset.copy ac
join asset.call_number acn ON acn.id = ac.call_number
join reporter.materialized_simple_record rmsr ON rmsr.id = acn.record
join asset.copy_location acl on acl.id = ac.location
join actor.org_unit aou ON aou.id = ac.circ_lib
join actor.org_unit aou2 on aou2.id = aou.parent_ou
where ac.status = 14 and aou2.shortname = 'YCL' and ac.deleted = FALSE
order by aou.shortname, acl.name, acn.label
;