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

[Andrea Buntz Neiman]

Hi Jennifer,

An alternative that I used when I worked at KCPL will show bibs that have
no copies but still have empty volumes attached (which can prevent a record
from auto-deleting):

Source -- Last Copy Delete Time

Displayed Fields:
Record ID (transform: Raw Data)
Delete Date/Time (Transform: Date)

Filter Field:
[Bib] Deleted = False  (Last Copy Delete Time :: Record ID)

This will return a list of Bib IDs for undeleted bibs, and the date the
last copy on the bib was deleted.  You can then go through and delete any
"stuck" empty volumes.

Andrea

On Wed, Jan 18, 2017 at 9:30 AM, Walz, Jennifer <jlwalz at asbury.edu> wrote:

> Blake,
>
>
>
> Thank you!   I will take a look at that.
>
>
>
> Jennifer
>
>
>
> *From:* Open-ils-general [mailto:open-ils-general-
> bounces at list.georgialibraries.org] *On Behalf Of *Blake Henderson
> *Sent:* Wednesday, January 18, 2017 9:11 AM
> *To:* open-ils-general at list.georgialibraries.org
> *Subject:* Re: [OPEN-ILS-GENERAL] Finding records in Evergreen that have
> no items attached?
>
>
>
> Jennifer,
>
>
> This sounds familiar. We developed an additional reporting source to make
> this easier for us. In case your goal was to find bibs that "used" to have
> copies attached. Take a look at
> https://bugs.launchpad.net/evergreen/+bug/1582354
>
> -Blake-
>
> Conducting Magic
>
> MOBIUS
>
> 573-234-4513 <(573)%20234-4513>
>
> 877-312-3517 <(877)%20312-3517>
>
> On 1/17/2017 6:16 PM, Walz, Jennifer 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
>
>
>
>
>
>
>



-- 
Andrea Buntz Neiman
Project Manager for Software Development
Equinox Open Library Initiative
abneiman at equinoxinitiative.org
1-877-OPEN-ILS (673-6457)
*www.equinoxinitiative.org <http://www.equinoxinitiative.org>*
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://libmail.georgialibraries.org/pipermail/open-ils-general/attachments/20170118/1d8422a9/attachment-0001.html>