Staff activity report

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

Staff activity report

Ma. Victoria H. Silva-Manuel
Hi.
I would like to know how to generate a report that includes each staff
activities for certain dates.
Thank you.

--
Ma. Victoria H. Silva-Manuel
Registered Librarian, 0003892
_______________________________________________
Koha mailing list  http://koha-community.org
[hidden email]
https://lists.katipo.co.nz/mailman/listinfo/koha
Reply | Threaded
Open this post in threaded view
|

Re: Staff activity report

Josef Moravec
Hello,

try this report:

https://wiki.koha-community.org/wiki/SQL_Reports_Library#Librarians_activity

Josef

pá 7. 10. 2016 v 4:22 odesílatel Ma. Victoria H. Silva-Manuel <
[hidden email]> napsal:

> Hi.
> I would like to know how to generate a report that includes each staff
> activities for certain dates.
> Thank you.
>
> --
> Ma. Victoria H. Silva-Manuel
> Registered Librarian, 0003892
> _______________________________________________
> Koha mailing list  http://koha-community.org
> [hidden email]
> https://lists.katipo.co.nz/mailman/listinfo/koha
>
_______________________________________________
Koha mailing list  http://koha-community.org
[hidden email]
https://lists.katipo.co.nz/mailman/listinfo/koha
Reply | Threaded
Open this post in threaded view
|

Re: Staff activity report

schnydszch
In reply to this post by Ma. Victoria H. Silva-Manuel
Hi! You can check on this post posted by a fellow Filipino librarian and also answered by the same http://koha.1045719.n5.nabble.com/REport-that-displays-the-bib-record-with-items-that-has-been-accomplished-by-each-staff-td5827651.html#a5827656.

Copy/pasted the reports for you (with some modification on the original post), here are the reports:

Reports of All Catalog Actions within a certain date based on Surname and First Name

SELECT
      b.title
    , b.author
    , i.itemnumber, i.itemcallnumber
    , i.barcode
    ,  l.action_id, l.user, l.module, l.action, l.object, l.info
    , br.borrowernumber
FROM items i
LEFT JOIN biblio b ON (i.biblionumber=b.biblionumber)
LEFT JOIN action_logs l ON (b.biblionumber=l.object) LEFT JOIN borrowers br on (l.user=br.borrowernumber)
WHERE
    br.surname = <<Enter Surname>> AND br.firstname = <<Enter Firstname>> AND date(i.timestamp) BETWEEN <<Between (yyyy-mm-dd)|date>>
      AND <<and (yyyy-mm-dd)|date>>


Reports of Added Catalog within a certain date based on Surname and First Name

SELECT
      b.title
    , b.author
    , i.itemnumber, i.itemcallnumber
    , i.barcode
    , l.action_id, l.user, l.module, l.action, l.object, l.info
    , br.borrowernumber
FROM items i
LEFT JOIN biblio b ON (i.biblionumber=b.biblionumber)
LEFT JOIN action_logs l ON (b.biblionumber=l.object) LEFT JOIN borrowers br on (l.user=br.borrowernumber)
WHERE
    br.surname = <<Enter Surname>> AND br.firstname = <<Enter Firstname>> AND date(i.timestamp) BETWEEN <<Between (yyyy-mm-dd)|date>>
      AND <<and (yyyy-mm-dd)|date>> AND action='ADD'


Reports of Modified/Edited Catalog within a certain date based on Surname and First Name

SELECT
      b.title
    , b.author
    , i.itemnumber, i.itemcallnumber
    , i.barcode
    , l.action_id, l.user, l.module, l.action, l.object, l.info
    , br.borrowernumber
FROM items i
LEFT JOIN biblio b ON (i.biblionumber=b.biblionumber)
LEFT JOIN action_logs l ON (b.biblionumber=l.object) LEFT JOIN borrowers br on (l.user=br.borrowernumber)
WHERE
    br.surname = <<Enter Surname>> AND br.firstname = <<Enter Firstname>> AND date(i.timestamp) BETWEEN <<Between (yyyy-mm-dd)|date>>
      AND <<and (yyyy-mm-dd)|date>> AND action='MODIFY'


Reports of All Catalog Actions within a certain date based on ID number

SELECT
      b.title
    , b.author
    , i.itemnumber, i.itemcallnumber
    , i.barcode
    ,  l.action_id, l.user, l.module, l.action, l.object, l.info
    , br.borrowernumber, br.cardnumber
FROM items i
LEFT JOIN biblio b ON (i.biblionumber=b.biblionumber)
LEFT JOIN action_logs l ON (b.biblionumber=l.object) LEFT JOIN borrowers br on (l.user=br.borrowernumber)
WHERE
    br.cardnumber = <<Enter ID number>> AND date(i.timestamp) BETWEEN <<Between (yyyy-mm-dd)|date>>
      AND <<and (yyyy-mm-dd)|date>>


Reports of All Added Catalog Actions within a certain date based on ID number

SELECT
      b.title
    , b.author
    , i.itemnumber, i.itemcallnumber
    , i.barcode
    ,  l.action_id, l.user, l.module, l.action, l.object, l.info
    , br.borrowernumber, br.cardnumber
FROM items i
LEFT JOIN biblio b ON (i.biblionumber=b.biblionumber)
LEFT JOIN action_logs l ON (b.biblionumber=l.object) LEFT JOIN borrowers br on (l.user=br.borrowernumber)
WHERE
    br.cardnumber = <<Enter ID number>> AND date(i.timestamp) BETWEEN <<Between (yyyy-mm-dd)|date>>
      AND <<and (yyyy-mm-dd)|date>> AND action='ADD'


Hope this helps.