[Koha] Staff activity report

[schnydszch]

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.




--
View this message in context: http://koha.1045719.n5.nabble.com/Staff-activity-report-tp5906107p5906146.html
Sent from the Koha-general mailing list archive at Nabble.com.