{13} Votes
Note:
See TracReports for help on using and creating reports.
ProgrammingError: column "resource" does not exist LINE 11: join (select resource, sum(vote) as votes from votes group... ^
SELECT COUNT(*) FROM ( SELECT p.value AS __color__, id AS ticket, summary, component, version, milestone, t.type AS type, owner, status, votes, changetime AS _changetime, description AS _description, reporter AS _reporter FROM ticket t LEFT JOIN enum p ON p.name = t.priority AND p.type = 'priority' join (select resource, sum(vote) as votes from votes group by resource) as v ON (v.resource = 'ticket/'||t.id) WHERE status <> 'closed' ORDER BY votes DESC, p.value, time ) AS tab
Powered by Trac 1.0.9
By Edgewall Software.
Visit the Trac open source project at
http://trac.edgewall.org/