Re: [Koha] Reports on comments written on opac

2010/3/4 Mark Osborne <mosborne@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