ticket,summary,type,release,owner,status,created,modified,_description,_reporter
6693,Suggested query for checking ratings,enhancement,0.11,,new,2010-02-18T21:15:29+01:00,2020-05-06T02:00:59+02:00,"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.",ibboard