[OPEN-ILS-GENERAL] Statiscial Categories report question

[Chris Sharp]

Sharon,

Getting that data from the Evergreen reporter is problematic because the reporter only allows you to join to a source once.  If you try to join it (that is, select the same field from the same source) again, you'll end up with a an error in the report creator and/or a query that errors out when the query runs on the database server.  PINES has custom sources/database views (that are optionally part of Evergreen) that include "Legacy Stat Cat 1" (which maps to the statistical category with id "1" in the database) and "Legacy Stat Cat 2" (which maps to the statistical category with id "2").  Those could be used as an example for your system person to create a custom view that would allow the 9 statistical categories you use.  Other than that, you're probably stuck doing (or asking your system admin to do) direct SQL queries to get the data you're after.

I would be willing to assist your technical staff in the creation of a view that could be accessible to the reporter if they need help.

Hope that's helpful!

Chris

----- Original Message -----
> From: "Sharon Douglas" <douglass at exchange.larl.org>
> To: "Evergreen Discussion Group" <open-ils-general at list.georgialibraries.org>
> Sent: Friday, January 29, 2016 5:03:54 PM
> Subject: Re: [OPEN-ILS-GENERAL] Statiscial Categories report question
> 
> I spoke to soon,
> I'm able to "sort of" get statistical category count data, but not circ data.
> So I'm still struggling with this and would greatly appreciate ideas from
> others.
> 
> Sharon Douglas
> Lake Agassiz Regional Library
> 
> 
> 
> From: Open-ils-general
> [mailto:open-ils-general-bounces at list.georgialibraries.org] On Behalf Of
> Deanna Frazee
> Sent: Thursday, 28 January, 2016 4:22 PM
> To: Evergreen Discussion Group
> Subject: Re: [OPEN-ILS-GENERAL] Statiscial Categories report question
> 
> Would you mind sharing your solution?  Getting circulation data from the stat
> cats has eluded me for some time now.
> 
> Thanks,
> 
> Deanna Frazee
> Director of Library Services
> Killeen City Library System
> City of Killeen, Texas
> 254-501-8995 (office)
> 254-501-7704 (fax)
> dfrazee at killeentexas.gov<mailto:http://dfrazee@killeentexas.gov>
> www.killeentexas.gov<http://www.killeentexas.gov/>
> 
> Dedicated Service - Every Day, for Everyone!
> 
> 
> 
> From: Open-ils-general
> [mailto:open-ils-general-bounces at list.georgialibraries.org] On Behalf Of
> Sharon Douglas
> Sent: Thursday, January 28, 2016 3:39 PM
> To: Evergreen Discussion Group
> Subject: Re: [OPEN-ILS-GENERAL] Statiscial Categories report question
> 
> You know how, when you've given up and decide to ask the collective for
> ideas?
> That's what I did.
> 
> And while I waited for one of you to quickly jump in with the best tip
> ever...
> I decided to try one more thing, and wouldn't you know, I figured it out.
> 
> So thanks for reading my email
> Next time I'm stuck, I'll take a coffee break and give my brain a little time
> to think of some idea I'd not yet tried.
> And only after that will I send out an email.
> 
> Sharon
> 
> 
> From: Sharon Douglas
> Sent: Thursday, 28 January, 2016 3:10 PM
> To: Evergreen Discussion Group
> (open-ils-general at list.georgialibraries.org<mailto:open-ils-general at list.georgialibraries.org>)
> Subject: Statiscial Categories report question
> 
> Hello everyone,
> We are new to Evergreen (by a few months) and I'm finally ready to gather
> statistical data, but I can't find it when putting together a report
> template.
> We have 9 specialized stat cats and I'd like to gather circulation data for
> each, but can't figure out where in the report feature to get at that data.
> I'm adding a screen shot with some of the stat cat data I need showing near
> the green areas.
> Please offer tips on finding this data.
> 
> Sharon Douglas
> Lake Agassiz Regional Library
> 
> [cid:image001.png at 01D15AAE.A5BA3BB0]
> 

-- 
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/