[OPEN-ILS-GENERAL] Finding records in Evergreen that have no items attached?

[Elisabeth Keppler]

At Forsyth, we run an empty bib record report using the following aggregate
filter:

[image: Inline image 1]
It does assume that you don't keep empty *volumes* if there are no *items*
attached.  Do beware of bib records that have 856-tags, though, as well as
serials (if you use them).  Just because there isn't an item on a bib
record doesn't necessarily mean it's dead.  We actually run a second report
of empties that have 856-tag entries so that we can use the VLOOKUP
function in Excel to pull them out of the first report.  Here's what the
base filters look like for that second report:

[image: Inline image 2]
The reason we include record creation date in the base filters is that we
don't want to accidentally discard brand new bib recs that have been
imported but not used yet.

Hope this helps!

Thanks,
Lise

On Tue, Jan 17, 2017 at 7:16 PM, Walz, Jennifer <jlwalz at asbury.edu> wrote:

> All –
>
>
>
> We need to find out if we have ‘empty’ records.   IS there a report
> template that I can modify that will show me all our records  with no items
> attached?  Maybe there is a source that is particularly helpful if I need
> to start from scratch?   Can someone advise me on how to find out this
> information.
>
>
>
> Thanks!
>
>
>
> Jennifer
>
> --------------------------------------------------
> Jennifer Walz, MLS - Head of ILS deletions
> Kinlaw Library  - Asbury University
> 1 Macklem Drive, Wilmore, KY 40390
> 859-858-3511 ext. 2269 <(859)%20858-3511>
> jlwalz at asbury.edu
>
>
>
>
>



-- 
Lise Keppler, Technical Services
Forsyth County Public Library
2851 Fairlawn Dr
Winston Salem NC  27106
336-703-3048
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://libmail.georgialibraries.org/pipermail/open-ils-general/attachments/20170118/1b39c9f6/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image.png
Type: image/png
Size: 155360 bytes
Desc: not available
URL: <http://libmail.georgialibraries.org/pipermail/open-ils-general/attachments/20170118/1b39c9f6/attachment-0002.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image.png
Type: image/png
Size: 145018 bytes
Desc: not available
URL: <http://libmail.georgialibraries.org/pipermail/open-ils-general/attachments/20170118/1b39c9f6/attachment-0003.png>