Suggested query for checking ratings
|Reported by:||ibboard||Owned by:||Ryan J Ollos|
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.