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

[Walz, Jennifer]

Andrea,

Ooo…  that looks nice too.   That would probably have been my follow up question.  ☺

Thanks!

Jennifer

From: Open-ils-general [mailto:open-ils-general-bounces at list.georgialibraries.org] On Behalf Of Andrea Buntz Neiman
Sent: Wednesday, January 18, 2017 9:53 AM
To: Evergreen Discussion Group
Subject: Re: [OPEN-ILS-GENERAL] Finding records in Evergreen that have no items attached?

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<mailto: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<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<mailto: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<tel:(573)%20234-4513>

877-312-3517<tel:(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<tel:(859)%20858-3511>
jlwalz at asbury.edu<mailto:jlwalz at asbury.edu>






--
Andrea Buntz Neiman
Project Manager for Software Development
Equinox Open Library Initiative
abneiman at equinoxinitiative.org<mailto: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/e0d37baa/attachment.html>