HI Nicole, Thanks for the information on the table containing the log information. I have managed to come up with a quick and dirty solution to my problem. For sharing purpose so that it can be improved upon, here is the query that show the items that where catalogue in the current month.
SELECT borrowers.surname, borrowers.firstname, action_logs.timestamp, action_logs.module, action_logs.action, biblio.title, biblio.author FROM action_logs, borrowers, biblio WHERE action_logs.module = 'CATALOGUING' AND action_logs.user = borrowers.borrowernumber AND biblio.biblionumber = action_logs.object AND ( year( action_logs.timestamp ) = YEAR( CURDATE( ) ) ) AND ( month( action_logs.timestamp ) = MONTH( CURDATE( ) ) ) Just wondering if there is somewhere where we can get the database schema for koha. Regards, Admire Mutsikiwa -----Original Message----- From: Nicole Engard [mailto:neng...@gmail.com] Sent: Wednesday, July 27, 2011 1:57 PM To: amutsikiwa Cc: koha@lists.katipo.co.nz Subject: Re: [Koha] Catalogue statitistics by Catataloguer Name Admire, I'm pretty sure that info is tracked in the action_logs table if you have the cataloging log turned on: http://manual.koha-community.org/3.4/en/administration.html#CataloguingLog Nicole 2011/7/27 amutsikiwa <amutsik...@uzlib.uz.ac.zw>: > Hi > > Hope I find you well. I have a super librarian who has four cataloguers > and is interested in establishing the number of items catalogued by each > cataloguer on a weekly and monthly basis. Is there anyone who have come up > with such a query. Or alternatively, can someone formulate the query for me, > for I am at a loss. > > > > Regards, > > > > Admire Mutsikiwa > > University of Zimbabwe > > _______________________________________________ > Koha mailing list http://koha-community.org > Koha@lists.katipo.co.nz > http://lists.katipo.co.nz/mailman/listinfo/koha > > -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
