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-boun...@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 <jlw...@asbury.edu<mailto:jlw...@asbury.edu>> wrote: Blake, Thank you! I will take a look at that. Jennifer From: Open-ils-general [mailto:open-ils-general-boun...@list.georgialibraries.org<mailto:open-ils-general-boun...@list.georgialibraries.org>] On Behalf Of Blake Henderson Sent: Wednesday, January 18, 2017 9:11 AM To: open-ils-general@list.georgialibraries.org<mailto:open-ils-general@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> jlw...@asbury.edu<mailto:jlw...@asbury.edu> -- Andrea Buntz Neiman Project Manager for Software Development Equinox Open Library Initiative abnei...@equinoxinitiative.org<mailto:abnei...@equinoxinitiative.org> 1-877-OPEN-ILS (673-6457) www.equinoxinitiative.org<http://www.equinoxinitiative.org>
