Awesome! Works like a charm. On 4 March 2010 08:53, Chris Cormack <chris@bigballofwax.co.nz> wrote:
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
-- Hei konā mai, Mark Osborne Deputy Principal, Albany Senior High School. Google Map: http://bit.ly/7cchi3 http://wikieducator.org/Albany_Senior_High_School http://wikieducator.org/Albany_Senior_High_School/ICTs