[Koha] Statistics for Shelving Location and Collection Code
nicole.engard at liblime.com
Wed May 27 10:07:07 NZST 2009
I'm sure it can be done. I did this one with item type and shelving
location - we can probably just change item type to collection code.
#Answers - how many new books added at each library sorted by shelving
location and item type:
SELECT count(i.biblionumber) as added, i.itype, i.homebranch,
i.location from items i WHERE YEAR(i.dateaccessioned) = 2008 AND
MONTH(i.dateaccessioned) = 10 GROUP BY i.homebranch,i.itype,i.location
ORDER BY i.homebranch,i.itype,i.location asc
If I get some time I can try to tweak - if not - then someone else can
try to tweak it :)
Nicole C. Engard
Open Source Evangelist, LibLime
(888) Koha ILS (564-2457) ext. 714
nce at liblime.com
On Tue, May 26, 2009 at 5:41 PM, Vicki Teal Lovely <vtl at scls.lib.wi.us> wrote:
> Does anyone know if you can circulation statistics for Shelving Location
> and Collection code by location? In Koha we may need to use a
> combination of these two codes for display purposes. This will make it
> difficult to get statistics since there could be many different
> combinations created in the item database.
> In Dynix the display function and statistical function are separated.
> Vicki Teal Lovely
> vtl at scls.lib.wi.us
> Software Applications Supervisor
> SCLS Automation
> 201 W. Mifflin St.
> Madison, WI 53703
> Koha mailing list
> Koha at lists.katipo.co.nz
More information about the Koha