[OPEN-ILS-GENERAL] Circ Stats - in house use? Report to use?

[Blake Henderson]

Jennifer,

Below is the data column for our "In House Usage Count by Library" 
template. I don't know if this will translate to your DB now that I'm 
seeing "alias" GUID table names. If it doesn't work, let me know and we 
can try to find another way to share it.

{"version":4,"doc_url":"","core_class":"aihu","select":[{"alias":"Use 
Date/Time","field_doc":"","column":{"colname":"use_time","transform":"month_trunc","transform_label":"Year 
+ 
Month"},"path":"aihu-use_time","relation":"e443e095dd88083d1a9da7e3630b7185"},{"alias":"Count","field_doc":"","column":{"colname":"id","transform":"count","transform_label":"Count"},"path":"aihu-id","relation":"e443e095dd88083d1a9da7e3630b7185"}],"from":{"path":"aihu-item","table":"action.in_house_use","label":"In 
House 
Use","alias":"e443e095dd88083d1a9da7e3630b7185","idlclass":"aihu","template_path":"aihu","join":{"item-e443e095dd88083d1a9da7e3630b7185":{"key":"id","path":"aihu-item-acp-circ_lib","table":"asset.copy","alias":"779b40433dc43e73dcaac579bd5519f8","join":{"circ_lib-779b40433dc43e73dcaac579bd5519f8":{"key":"id","path":"aihu-item-acp-circ_lib-aou","table":"actor.org_unit","label":"In 
House Use -> Item :: Circulating 
Library","alias":"da555701199aeb1674faf7ac59d6ebea","idlclass":"aou","template_path":"aihu-item.acp-circ_lib"}}}}},"where":[{"alias":"Use 
Date/Time","field_doc":"","column":{"colname":"use_time","transform":"date","transform_label":"Date"},"path":"aihu-use_time","relation":"e443e095dd88083d1a9da7e3630b7185","condition":{"between":"::P0"}},{"alias":"Organizational 
Unit 
ID","field_doc":"","column":{"colname":"id","transform":"Bare","transform_label":"Raw 
Data"},"path":"aihu-item-acp-circ_lib-aou-id","relation":"da555701199aeb1674faf7ac59d6ebea","condition":{"in":"::P1"}}],"having":[],"order_by":[],"rel_cache":{"e443e095dd88083d1a9da7e3630b7185":{"label":"In 
House 
Use","alias":"e443e095dd88083d1a9da7e3630b7185","path":"aihu","join":"","reltype":"","idlclass":"aihu","table":"action.in_house_use","fields":{"dis_tab":{"id":{"colname":"id","transform":"count","aggregate":true,"params":null,"transform_label":"Count","alias":"Count","join":"","datatype":"id","op":"=","op_label":"Equals","op_value":{},"field_doc":""},"use_time":{"colname":"use_time","transform":"month_trunc","aggregate":null,"params":null,"transform_label":"Year 
+ Month","alias":"Use 
Date/Time","join":"","datatype":"timestamp","op":"=","op_label":"Equals","op_value":{},"field_doc":""}},"filter_tab":{"use_time":{"colname":"use_time","transform":"date","aggregate":null,"params":null,"transform_label":"Date","alias":"Use 
Date/Time","join":"","datatype":"timestamp","op":"between","op_label":"Between","op_value":{},"field_doc":""}},"aggfilter_tab":{}}},"order_by":[{"relation":"e443e095dd88083d1a9da7e3630b7185","field":"use_time"},{"relation":"e443e095dd88083d1a9da7e3630b7185","field":"id"}],"da555701199aeb1674faf7ac59d6ebea":{"label":"In 
House Use -> Item :: Circulating 
Library","alias":"da555701199aeb1674faf7ac59d6ebea","path":"aihu-item.acp-circ_lib","join":"","reltype":"has_a","idlclass":"aou","table":"actor.org_unit","fields":{"dis_tab":{},"filter_tab":{"id":{"colname":"id","transform":"Bare","aggregate":null,"params":null,"transform_label":"Raw 
Data","alias":"Organizational Unit 
ID","join":"","datatype":"org_unit","op":"in","op_label":"In 
list","op_value":{},"field_doc":""}},"aggfilter_tab":{}}}}}

-Blake-
Conducting Magic
MOBIUS
573-234-4513
877-312-3517

On 11/9/2015 2:01 PM, Walz, Jennifer wrote:
> Chris,
>
>    Excellent!   I forget about the sources dropdown.    That is a good place to start.
>
>    Any suggestions for which items I should select from that source that are the most helpful?   Anyone have a great template they would like to share?   I have no idea how in house use works, so I am not sure what I should be looking for.   (and I am creating this for another library in our group)
>
>   Thanks!
>
> Jennifer
>
> -----Original Message-----
> From: Open-ils-general [mailto:open-ils-general-bounces at list.georgialibraries.org] On Behalf Of Chris Sharp
> Sent: Monday, November 09, 2015 2:50 PM
> To: Evergreen Discussion Group
> Subject: Re: [OPEN-ILS-GENERAL] Circ Stats - in house use? Report to use?
>
> Hi Jennifer,
>
> "In House Use" is one of the "Core Sources" available in the reports interface.  That should give you a good starting place for creating a template.
>
> Does that help?
>
> Chris
>
> ----- Original Message -----
>> From: "Jennifer Walz" <jlwalz at asbury.edu>
>> To: "open-ils-general at list.georgialibraries.org"
>> <open-ils-general at list.georgialibraries.org>
>> Sent: Monday, November 9, 2015 2:46:28 PM
>> Subject: [OPEN-ILS-GENERAL] Circ Stats - in house use?   Report to use?
>>
>> All -
>>
>>     We are trying to work out a report that will give us the stats by month
>>     for IN house use.   How do I do that?
>>
>> Thanks!
>>
>> Jennifer
>> --------------------------------------------------
>> Jennifer Walz, MLS - Head of ILS Report generation Kinlaw Library  -
>> Asbury University
>> 1 Macklem Drive, Wilmore, KY 40390
>> 859-858-3511 ext. 2269
>> jlwalz at asbury.edu
>>
>>
> --
> Chris Sharp
> PINES System Administrator
> Georgia Public Library Service
> 1800 Century Place, Suite 150
> Atlanta, Georgia 30345
> (404) 235-7147
> csharp at georgialibraries.org
> http://pines.georgialibraries.org/