Suggested query for checking ratings

[ibboard]

As it stands, this hack creates all of the votes in a separate table. As I'm using the voting to rank tickets/bugs/features that people think are important, it is useful to get an overview of which tickets have what rating. My current query to do this is:

select id, type, summary, component, milestone, owner, (sum(v.vote)/count(v.resource))||'/5' as rating, count(v.resource) as votes
from ticket t left join fivestarvote v on 'ticket/'||t.id = v.resource
group by t.id
order by rating desc

It might be useful to include something like that in the default install, if possible, so that people can have easy access to the information.

[Steffen Hoffmann]

An example report should be include, sure.

But note that moving towards an improved db schema like done for VotePlugin lately will obsolete non-portable string-concatenation inside the report SQL and save the hassle of providing db backend-specific versions of the report. The currently proposed statement will not work with MySQL IIRC.