[Koha] Reports on comments written on opac
Chris Cormack
chris at bigballofwax.co.nz
Thu Mar 4 08:53:27 NZDT 2010
2010/3/4 Mark Osborne <mosborne at ashs.school.nz>:
> Hello,
> Is there an easy way to see which of our patrons has written comments on
> items in the OPAC and how many comments they have written? I'd like to see
> who has done this and who our most active 'reviewers' are.
> Thanks,
>
You could do this with some SQL in the reports module
SELECT cardnumber,firstname,surname, count(reviewid) FROM borrowers,
reviews WHERE reviews.borrowernumber = borrowers.borrowernumber GROUP
BY cardnumber,firstname,surname
Chris
More information about the Koha
mailing list