Reports on comments written on opac
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, -- 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
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
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
participants (2)
-
Chris Cormack -
Mark Osborne