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@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@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@scls.lib.wi.us
Software Applications Supervisor SCLS Automation 201 W. Mifflin St. Madison, WI 53703
(608)261-9109
_______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha