Hi: Try this:
SELECT user AS 'user',count(user) AS 'items added' FROM action_logs WHERE module='CATALOGUING' AND info like 'BEFORE%' AND action='MODIFY' GROUP BY user; I am not sure if the string "BEFORE" is always for bibs, but so it seems. Maybe you can do something alike from logs, too. Greetings, Ramiro 2014-05-14 15:08 GMT-03:00 حسين رضوي <[email protected]>: > Hi, > > Is there any way to find out how many biblio was modified by each staff of > our library? > We want to get a reports showing to us the biblio and date to each employee > separately. > Mr Bernardo Help me and find something on > > http://wiki.koha-community.org/wiki/SQL_Reports_Library#Titles_added_by_catalogerbut > we need to know how many record was edited by each user. > > Many thanks > Hussain A. > _______________________________________________ > Koha mailing list http://koha-community.org > [email protected] > http://lists.katipo.co.nz/mailman/listinfo/koha > _______________________________________________ Koha mailing list http://koha-community.org [email protected] http://lists.katipo.co.nz/mailman/listinfo/koha
