How do I create a list of titles with holds but no copies owned by my library?
Applies to
- Wise configuration
Answer
This information can be gathered by running the following query in the Manager at SystemWise > Reports > Report processor, on the Queries tab:
select titelnr
from reservering where status = 'A'
and titelnr not in(select titelnr from exemplaren)
limit 1000