[Koha] Statistics for Shelving Location and Collection Code

[Nicole Engard]

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
AIM/Y!/Skype: nengard

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



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