Re: [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 | tmcca...@georgialibraries.org

http://help.georgialibraries.org | h...@help.georgialibraries.org




Join our email list  for stories of Georgia
libraries making an impact in our communities.



On Wed, Oct 23, 2019 at 6:26 PM Mary Llewellyn  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 <
> margueritegr...@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
> mllew...@biblio.org
>

Re: [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 <
margueritegr...@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
mllew...@biblio.org