Re: [OPEN-ILS-GENERAL] Records with no items

2019-10-24 Thread Terran McCanna
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

Re: [OPEN-ILS-GENERAL] Records with no items

2019-10-23 Thread Mary Llewellyn
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')

[OPEN-ILS-GENERAL] Records with no items

2019-10-23 Thread Marguerite Grant
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