[OPEN-ILS-GENERAL] Records with no items

[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')

My SQL syntax skills are kind of rudimentary. I'm sure someone else can
write something more elegant. This one is looking for biblio.record ids
that are not associated with undeleted call numbers and bibs

Maybe this example will give insight on tables and parameters to use in a
report.

Mary


On Wed, Oct 23, 2019 at 10:44 AM Marguerite Grant <
margueritegrant at rodgerslibrary.org> wrote:

> 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 very much for any help you can give me.
>
> Marguerite Grant
>
> ---
>
> Rodgers Memorial Library
>
> Hudson, NH
>


-- 
Mary Llewellyn
Database Manager
Bibliomation, Inc.
24 Wooster Ave.
Waterbury, CT 06708
mllewell at biblio.org
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://libmail.georgialibraries.org/pipermail/open-ils-general/attachments/20191023/b22dd809/attachment.html>