[Koha] Reports on comments written on opac

[Chris Cormack]

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