Title: trac Report for Feature Voting
Author: Alex Kirk
Published: January 27, 2011

---

# trac Report for Feature Voting

January 27, 2011

I use [trac](http://trac.edgewall.org/) for quite a few projects of mine. Recently
I tried to find a plugin for deciding which features to implement next. Usually 
[trac hacks](http://www.trac-hacks.org/) has something in store for that, but not
this time.

I wanted to be able to create a ticket and then collect user feedback as comments
for the feature, with each piece of feedback being a vote for that feature, like
this:

![](https://alex.kirk.at/wp-content/uploads/sites/2/2011/01/report.png "report")

After searching for a bit I came up with a solution by using just a report with 
a nicely constructed SQL query.

    ```
    SELECT p.value AS __color__,
       t.type AS `type`, id AS ticket, count(tc.ticket) as votes, summary, component, version, milestone,
       t.time AS created,
       changetime AS _changetime, description AS _description,
       reporter AS _reporter
      FROM ticket t, ticket_change tc, enum p
      WHERE t.status <> 'closed'
    AND tc.ticket = t.id and tc.field = 'comment' and tc.newvalue like '%#vote%'
    AND p.name = t.priority AND p.type = 'priority'
    GROUP BY id, summary, component, version, milestone, t.type, owner, t.time,
      changetime, description, reporter, p.value, status
    HAVING count(tc.ticket) >= 1
     ORDER BY votes DESC, milestone, t.type, t.time
    ```

So just by including “#vote” in a comment, it would count towards the number of 
votes. You can change this text to anything you want, of course. For example like
this:

![](https://alex.kirk.at/wp-content/uploads/sites/2/2011/01/vote-comments.png "vote-
comments")

I hope this can be useful for someone else, too.

[Code](https://alex.kirk.at/category/code/), [Projects](https://alex.kirk.at/category/projects/)

Read this next

[iOS 2011 Alarm Clock Bug](https://alex.kirk.at/2011/01/11/ios-2011-alarm-clock-bug/)

### Leave a Reply 󠀁[Cancel reply](https://alex.kirk.at/2011/01/27/trac-report-for-feature-voting/?output_format=md#respond)󠁿

Only people in [my network](https://alex.kirk.at/friends/) can comment.

This site uses Akismet to reduce spam. [Learn how your comment data is processed.](https://akismet.com/privacy/)