[OPEN-ILS-GENERAL] Reports - Item Source - Parent circulation?

[John Amundson]

Hi, Jennifer:

In case it is simply the former, I wanted to pass along a mockup of a
template I created that should work for you before I head home for the
day...

You can start from either the Report Source *Item *or *Circulation*, but I
prefer starting from *Circulation; *from there you can get to the Item via
the *Circulating Item *link. Below is a look at a possible setup in the web
client. The XUL client should be very similar. The most important piece is
filtering on "Check In Date/Time *Is NULL*" as this limits checkouts to
only current ones.

The following will get you a list of items that are currently checked out
and the patron who has them out.

Note that this current setup will only output items in copy status Checked
Out as per your request. It can be altered to include checked out items in
other statuses as well, (Lost, Long Overdue, etc) by adding the filter
"Transaction Finish Date/Time *Is NULL*" and removing the filter "Copy
Status... id *equals 1*".

Displayed fields:



Filters:






<http://www.cwmars.org>

John Amundson | Library Applications Associate III | CW MARS

jamundson at cwmars.org | 508-755-3323 x322 <%28508%29%20755-3323>

http://www.cwmars.org

On Tue, Jul 31, 2018 at 4:45 PM, John Amundson <jamundson at cwmars.org> wrote:

> 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
>
>
>
>
> <http://www.cwmars.org>
>
> John Amundson | Library Applications Associate III | CW MARS
>
> jamundson at cwmars.org | 508-755-3323 x322 <%28508%29%20755-3323>
>
> http://www.cwmars.org
>
> On Tue, Jul 31, 2018 at 3:16 PM, Walz, Jennifer <jlwalz at 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
>> jlwalz at asbury.edu
>>
>>
>>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://libmail.georgialibraries.org/pipermail/open-ils-general/attachments/20180731/2564dd4d/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image.png
Type: image/png
Size: 20594 bytes
Desc: not available
URL: <http://libmail.georgialibraries.org/pipermail/open-ils-general/attachments/20180731/2564dd4d/attachment-0002.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image.png
Type: image/png
Size: 36827 bytes
Desc: not available
URL: <http://libmail.georgialibraries.org/pipermail/open-ils-general/attachments/20180731/2564dd4d/attachment-0003.png>