Terran, I was doing something very similar, but instead of JUST the last circ, I was getting all kinds of results. But I will try it again. Maybe I was selecting the wrong source to start with.
Thanks! Jennifer From: Open-ils-general [mailto:open-ils-general-boun...@list.georgialibraries.org] On Behalf Of Terran McCanna Sent: Tuesday, July 31, 2018 8:30 PM To: Evergreen Discussion Group Subject: Re: [OPEN-ILS-GENERAL] Reports - Item Source - Parent circulation? Hi Jennifer, I would built that report like this: Source: Classic Item List Filters: Status > id (Operater = In List) Owning Library > id (Operator = In List) Deleted (Operator = Equals, Filter Value = f) Display Fields: Circ Modifier Callnumber Label Title Barcode Patron Barcode Patron Name Terran McCanna PINES Program Manager Georgia Public Library Service tmcca...@georgialibraries.org<mailto:tmcca...@georgialibraries.org> * The GPLS office is in the midst of relocating offices. We may be reached by all of the current mechanisms during the transition, but to ensure the most prompt response, please use the Help Desk: https://help.georgialibraries.org On Tue, Jul 31, 2018 at 4:57 PM, Walz, Jennifer <jlw...@asbury.edu<mailto:jlw...@asbury.edu>> wrote: John, I would like the CURRENT item checked out with the CURRENT patron name who has it. It would be great to see all the items with the status of checkedout, for our location, with a borrower listed for each item who has the item out. Is that the ‘active circulation’?? What are ‘linked’ circulations? WHY is this so hard? Don’t libraries want to know how many items are out currently, what they are, and who has them? Should be a ‘one-click’ report. Thanks! Jennifer From: Open-ils-general [mailto:open-ils-general-boun...@list.georgialibraries.org<mailto:open-ils-general-boun...@list.georgialibraries.org>] On Behalf Of John Amundson Sent: Tuesday, July 31, 2018 4:46 PM To: Evergreen Discussion Group Subject: Re: [OPEN-ILS-GENERAL] Reports - Item Source - Parent circulation? Hi, Jennifer: Are you looking to get information for the patron who CURRENTLY has the item checked out or for the patron who had the item checked out PRIOR to the current checkout? The former is easy, the latter... may not be as friendly. The Parent Circulation relates to renewals. If an item is renewed, the parent circ was the circulation that led to the renewal. John [https://lh5.googleusercontent.com/C1fNrKOLEXFs-jfAIXQIMqbKqVBCJrBceOenfgotAcJE6XtZ2ZeeTYFkyfir63-HfzjX6q5zhBQWiO5RZk2tYnWzJ1_rjAADAH4nCmiuhNJuoG8HZLq7MBW-pAU4R9ScKcCybdVO]<http://www.cwmars.org> John Amundson | Library Applications Associate III | CW MARS jamund...@cwmars.org<mailto:jamund...@cwmars.org> | 508-755-3323 x322<tel:%28508%29%20755-3323> http://www.cwmars.org<http://www.cwmars.org/> On Tue, Jul 31, 2018 at 3:16 PM, Walz, Jennifer <jlw...@asbury.edu<mailto:jlw...@asbury.edu>> wrote: All – I’m trying to get a report to run with the LAST circulating patron on items currently checked out. Is that the Parent Circulation? What IS the parent circulation? If not, what is the data point in the Item Source to help me get to that information? I want a report with this information: current status=checked out, list of item barcode, title, call number, and circ mod. Also need for each item, the LAST circ patron (i.e. the one who has it out now) with barcode and last name. Any advice is welcome. Thanks! Jennifer -------------------------------------------------- Jennifer Walz, MLS - Head of ILS Reporting Mania Kinlaw Library - Asbury University One Macklem Drive, Wilmore, KY 40390 859-858-3511 ext. 2269 jlw...@asbury.edu<mailto:jlw...@asbury.edu>