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

2018-08-01 Thread Walz, Jennifer 
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 
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

http://www.cwmars.org<http://www.cwmars.org/>


On Tue, Jul 31, 2018 at 3:16 PM, Walz, Jennifer 
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>

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

2018-07-31 Thread Terran McCanna 
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

* 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  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] *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
>
>
>
>
>
>
>
>
> <http://www.cwmars.org>
>
> John Amundson | Library Applications Associate III | CW MARS
>
> jamund...@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  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
>
>
>
>
>

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

2018-07-31 Thread Walz, Jennifer 
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] 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

http://www.cwmars.org<http://www.cwmars.org/>


On Tue, Jul 31, 2018 at 3:16 PM, Walz, Jennifer 
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>

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

2018-07-31 Thread 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:








John Amundson | Library Applications Associate III | CW MARS

jamund...@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  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
>
>
>
>
> 
>
> John Amundson | Library Applications Associate III | CW MARS
>
> jamund...@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  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
>>
>>
>>
>
>

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

2018-07-31 Thread John Amundson 
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






John Amundson | Library Applications Associate III | CW MARS

jamund...@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  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
>
>
>