Re: [OPEN-ILS-GENERAL] SQL Library

2015-06-12 Thread Chris Sharp
Don, We also have the magic spells wiki page that has some useful queries: http://wiki.evergreen-ils.org/doku.php?id=scratchpad:random_magic_spells Hope that helps! Chris - Original Message - From: Kathy Lussier kluss...@masslnc.org To: open-ils-general@list.georgialibraries.org

Re: [OPEN-ILS-GENERAL] SQL Library

2015-06-12 Thread Kathy Lussier
Hi Don, A few years ago, the Reports Interest Group created a wiki page for people to share SQL reports and one to share sample templates that would be available in the reporter. Both pages are accessible from http://wiki.evergreen-ils.org/doku.php?id=evergreen-reports. However, it looks

[OPEN-ILS-GENERAL] SQL Library

2015-06-12 Thread Donald Butterworth
Colleagues, At a conference I've been attending this week I learned about Koha's SQL Reports Library http://wiki.koha-community.org/wiki/SQL_Reports_Library. Does Evergreen have something similar? If not, do you think it would be a good idea to create one? Don -- Don Butterworth Faculty

Re: [OPEN-ILS-GENERAL] SQL Library

2015-06-12 Thread Galen Charlton
Hi, On Fri, Jun 12, 2015 at 10:39 AM, Rogan Hamby rogan.ha...@yclibrary.net wrote: I always meant to post some reports on it but I've never had a sense of what may be useful to people. From general experience with the Koha SQL and jQuery libraries, I suggest not sweating it: if it's useful to

Re: [OPEN-ILS-GENERAL] SQL Library

2015-06-12 Thread Geoff Sams
I might be willing to add some stuff to that myself, though I don’t know that I have many SQL queries to contribute, I might have some reports to contribute. Thanks, Geoff Sams Library Manager Roanoke Public Library From: Open-ils-general

Re: [OPEN-ILS-GENERAL] SQL Library

2015-06-12 Thread McCanna, Terran
I'm sure we could come up with some reports to add too, if it's something that people would find useful. Terran McCanna PINES Program Manager Georgia Public Library Service 1800 Century Place, Suite 150 Atlanta, GA 30345 404-235-7138 tmcca...@georgialibraries.org - Original Message

Re: [OPEN-ILS-GENERAL] SQL Library

2015-06-12 Thread Geoff Sams
+1 to that! Thanks, Geoff Sams Library Manager Roanoke Public Library -Original Message- From: Open-ils-general [mailto:open-ils-general-boun...@list.georgialibraries.org] On Behalf Of Galen Charlton Sent: Friday, June 12, 2015 9:46 AM To: Evergreen Discussion Group Subject: Re:

Re: [OPEN-ILS-GENERAL] SQL Library

2015-06-12 Thread Rogan Hamby
I'll throw a couple in I get regular questions about in the next few minutes. On Fri, Jun 12, 2015 at 11:26 AM, Jessica Venturo jvent...@biblio.org wrote: I would be excited to see this wiki page revived! I think I have a few queries that I can add too, with my fledgling SQL skills. We can

Re: [OPEN-ILS-GENERAL] SQL Library

2015-06-12 Thread Jessica Venturo
I would be excited to see this wiki page revived! I think I have a few queries that I can add too, with my fledgling SQL skills. We can certainly discuss the different types of queries people are looking for at the next Reports Interest Group meeting, which will be in the Fall. On Fri, Jun 12,