how many biblio was modified by each staff
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_cata... we need to know how many record was edited by each user. Many thanks Hussain A.
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 حسين رضوي <reza0770@gmail.com>:
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_cata... we need to know how many record was edited by each user.
Many thanks Hussain A. _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
participants (2)
-
ramirouvia . -
حسين رضوي