[OPEN-ILS-GENERAL] Records with no items

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

Georgia Public Library Service | University System of Georgia

2872 Woodcock Blvd, Suite 250 l Atlanta, GA 30341

(404) 235-7138 | tmccanna at georgialibraries.org

http://help.georgialibraries.org | help at help.georgialibraries.org

<https://www.facebook.com/georgialibraries>
<https://www.twitter.com/georgialibs>

Join our email list <http://georgialibraries.org> for stories of Georgia
libraries making an impact in our communities.



On Wed, Oct 23, 2019 at 6:26 PM Mary Llewellyn <mllewell at biblio.org> wrote:

> 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/20191024/41746191/attachment.html>