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 = <> AND br.firstname = <>
AND date(i.timestamp) BETWEEN <>
AND <>
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 = <> AND br.firstname = <>
AND date(i.timestamp) BETWEEN <>
AND <> 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 = <> AND br.firstname = <>
AND date(i.timestamp) BETWEEN <>
AND <> 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 = <> AND date(i.timestamp) BETWEEN
<>
AND <>
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 = <> AND date(i.timestamp) BETWEEN
<>
AND <> 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.
___
Koha mailing list http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha
