2008/6/24 Noah Kantrowitz <[EMAIL PROTECTED]>: > Can we install VotePlugin on t.e.o? I have a report to do summaries > using that instead and it might be clearer to people that those > numbers matter. > > SELECT p.value AS __color__, > id AS ticket, sum(v.vote) as votes, summary, component, version, > milestone, t.type AS type, > owner, status, > time AS created, > changetime AS _changetime, description AS _description, > reporter AS _reporter > FROM ticket t, enum p, votes v > WHERE status <> 'closed' > AND p.name = t.priority AND p.type = 'priority' > AND v.resource = 'ticket/' || id > GROUP BY id, summary, component, version, milestone, t.type, owner, > time, > changetime, description, reporter, p.value, status > ORDER BY votes DESC, milestone, t.type, time
http://trac.edgewall.org/report/34 -- And the next thing you know, you're at the zoo, shaving a yak, all so you can wax your car. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Trac Development" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/trac-dev?hl=en -~----------~----~----~----~------~----~------~--~---
