[Koha] SQL report

[Nicole Engard]

Last week I updated this document:
http://sites.google.com/a/liblime.com/koha-manual/Home/Table-of-Contents/Reports/reports-wizards
to include a tip about dates.

"TIP: The statistic reports are exclusive, so, if you want a report to
show data for the month of November you should pick October 31 to
December 1."

So if you want the month of December you should do December 1 to January 1.


---

Nicole C. Engard
Open Source Evangelist, LibLime
(888) Koha ILS (564-2457) ext. 714
nce at liblime.com
AIM/Y!/Skype: nengard

http://liblime.com
http://blogs.liblime.com/open-sesame/



On Mon, Dec 8, 2008 at 7:36 PM, Kathy Rippel <kdr at ckls.org> wrote:
> 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.
>
>
>
>
>
>
> _______________________________________________
> Koha mailing list
> Koha at lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha
>