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> wrote: > Blake, > > > > Thank you! I will take a look at that. > > > > Jennifer > > > > *From:* Open-ils-general [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 > *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> > jlw...@asbury.edu > > > > > > > -- Andrea Buntz Neiman Project Manager for Software Development Equinox Open Library Initiative abnei...@equinoxinitiative.org 1-877-OPEN-ILS (673-6457) *www.equinoxinitiative.org <http://www.equinoxinitiative.org>*
