We have a report that identifies volumes with no copies attached if that
helps - it uses the Call Number/Volume data source and filters by:
Is Deleted (equals f)
Owning Library (In list)
Copies > Is Deleted (equals f)
Copies > Copy ID (is NULL)
Terran McCanna, PINES Program Manager
I use SQL to identify records like that. My query is something like this:
select bre.id
from biblio.record_entry bre
where bre.deleted = 'f'
and bre.id not in
(select bre.id
from biblio.record_entry bre, asset.call_number acn
where acn.record = bre.id
and acn.deleted = 'f'
and bre.deleted = 'f')
We have been trying to identify active (not deleted) records that have no
active (not deleted) items. I haven't had any success creating a report.
Is there a canned report to do this and if not, perhaps someone can send me
some insight as to what tables and parameters I should be using.
Thanks