[Koha] Reports on comments written on opac

[Mark Osborne]

Awesome! Works like a charm.

On 4 March 2010 08:53, Chris Cormack <chris at bigballofwax.co.nz> wrote:

> 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
>



-- 
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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.katipo.co.nz/pipermail/koha/attachments/20100304/7f1d668d/attachment.htm