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-boun...@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" <jlw...@asbury.edu>
To: "open-ils-general@list.georgialibraries.org"
<open-ils-general@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
jlw...@asbury.edu
--
Chris Sharp
PINES System Administrator
Georgia Public Library Service
1800 Century Place, Suite 150
Atlanta, Georgia 30345
(404) 235-7147
csh...@georgialibraries.org
http://pines.georgialibraries.org/
