[Koha] how many biblio was modified by each staff

[ramirouvia .]

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 at 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_catalogerbut
> we need to know how many record was edited by each user.
>
> Many thanks
> Hussain A.
> _______________________________________________
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha
>