[Koha] SQL report

Sharon Moreland smoreland at nekls.org
Mon Dec 15 03:40:17 NZDT 2008


Inclusive data for the month of November would be Nov 1 to Dec 1 or  
Oct 31 to Dec 1? The examples below are conflicting.  From my testing,  
I think it's Nov 1 to Dec 1.  For a daily report it would be Dec 5 to  
Dec 6 to get stats for Dec 5.


Sharon
NExpress Shared Catalog

On Dec 12, 2008, at 5:57 AM, Nicole Engard wrote:

> 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
>>
> _______________________________________________
> Koha mailing list
> Koha at lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha



More information about the Koha mailing list