 |
 |
Evergreen uses Postgres as it's database so you can generate statistics similar to Koha with db access and the code will be pretty similar to what Cab posted for Koha (db structure and syntax varies of course). Additionally, Evergreen has a built in reporter that provides an abstraction layer for the staff client to run reports off the database. Finally, option three is that you can always connect an external reporting tool like Jasper reports. On Wed, Jan 14, 2015 at 9:11 AM, Cab Vinton <[log in to unmask]> wrote: > Koha has a very robust SQL-based reporting module, so generating > statistics like these is generally a fairly routine process. > > This report lists the top 10 circulating items in the last 6 months, for > example -- > > SELECT count(s.datetime) AS circs, b.title, b.author, i.ccode > FROM statistics s > JOIN items i ON (i.itemnumber=s.itemnumber) > LEFT JOIN biblio b ON (b.biblionumber=i.biblionumber) > WHERE DATE(s.datetime) > DATE_SUB(CURRENT_DATE(),INTERVAL 6 MONTH) > AND DATE(s.datetime)<=CURRENT_DATE() AND s.itemnumber IS NOT NULL > GROUP BY b.biblionumber > ORDER BY circs DESC > LIMIT 10 > > Constantly growing list of user-contributed reports here: > http://wiki.koha-community.org/wiki/SQL_Reports_Library/ > > Can't speak to Aleph, but there is a Developer's Network which should > point you in the right direction: > https://developers.exlibrisgroup.com/ > > Best, > > Cab Vinton > Plaistow Public Library > -- Rogan Hamby, MLS, CCNP, MIA Managers Headquarters Library and Reference Services, York County Library System “You can never get a cup of tea large enough or a book long enough to suit me.” ― C.S. Lewis <http://www.goodreads.com/author/show/1069006.C_S_Lewis>