[Koha] Catalogue statitistics by Catataloguer Name

[amutsikiwa]

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:nengard at gmail.com] 
Sent: Wednesday, July 27, 2011 1:57 PM
To: amutsikiwa
Cc: koha at 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 <amutsikiwa at 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 at 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.