Thank you very much On Wed, Feb 19, 2014 at 5:34 AM, Karam Qubsi <karamqubsi@gmail.com> wrote:
Hi , in my library I'm using this report , and I think this is the same report you want :
SELECT l.action, count(l.timestamp) AS 'bibs' FROM action_logs l LEFT JOIN borrowers p ON (p.borrowernumber=l.user) WHERE module='CATALOGUING' AND date(l.timestamp) BETWEEN <<Between (yyyy-mm-dd)>> AND <<and (yyyy-mm-dd)>> AND l.info!='item' AND user=<<user no.>> GROUP BY l.action
this report will ask you for date range and cataloger no . then the results would be something like this :
action bibs ADD 193 DELETE 10 MODIFY 1010 Note : the above report is modified by me the source is here : http://wiki.koha-community.org/wiki/SQL_Reports_Library where the report name there is :
- 5.83 Bib records added/deleted in time frame<http://wiki.koha-community.org/wiki/SQL_Reports_Library#Bib_records_added.2Fdeleted_in_time_frame> developed by Nicole C. Engard, ByWater Solutions -
Best wishes .
On Thu, Feb 13, 2014 at 11:21 PM, Nisreen Qabbani < nisreenqabbani@gmail.com> wrote:
Hello Can you help me how to know the number of bibliographic records for each employee account
Thank you very much _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
-- *Karam Qubsi*