[Koha] SQL report

Kathy Rippel kdr at ckls.org
Tue Dec 9 13:36:47 NZDT 2008


Josh-

I tried this on Great Bend Public Library's collection and have a few 
observations.

If the to/from date is the same (12/08 - 12/08), the result is zero.

So I tried 12/08 - 12/09 and then got a figure.


Kathy


At 02:47 AM 12/6/2008, Joshua Ferraro wrote:
>Hi Katharine,
>
>On Fri, Dec 5, 2008 at 6:22 PM, Katharine Dixon
><katharin at ci.salinas.ca.us> wrote:
> > Hello, I am new to the list so sorry if this has been asked before but does
> > anybody have the SQL for a report that would just give me a total of all
> > items circulated on a certain day.  Just the number, no titles or types.
>You can find this out from the Circulation Statistics wizard, located
>in the Reports area.
>The path is /cgi-bin/koha/reports/issues_stats.pl
>
>Select Period as a row, and specify the dates in question as From/To.
>
>Select Library as a Column
>
>Run the report and you will get a chart of circulations per branch for
>that date range.
>
>Cheers,
>
>--
>Joshua Ferraro                       SUPPORT FOR OPEN-SOURCE SOFTWARE
>CEO                         migration, training, maintenance, support
>LibLime                                Featuring Koha Open-Source ILS
>jmf at liblime.com |Full Demos at http://liblime.com/koha |1(888)KohaILS
>_______________________________________________
>Koha mailing list
>Koha at lists.katipo.co.nz
>http://lists.katipo.co.nz/mailman/listinfo/koha

Kathy Rippel
Dept. Head/Consultant--Resource Sharing and Access ;
Pathfinder Central (Manager)
Central Kansas Library System
1409 Williams
Great Bend, KS 67530

(620-792-4865) phone
(800-362-2642) toll-free, KS
(620-792-5495) fax

kdr at ckls.org
********************************************************************************************
I'm currently reading: Redesigning the American Lawn, by F. Herbert 
Bormann [... et al.]
I'm currently listening to: Xenocide, by Orson Scott Card.








More information about the Koha mailing list