assembla.com 的Trac 提供了几个默认的Report查询. 这里共享一个我们使用的比较实用的Report 查询。
SELECT distinct
ticket.id AS ticket,
ticket.reporter AS __group__,
ticket_change.author AS 'Changed by',
ticket.changetime AS modified,
ticket.owner,
ticket.status,
ticket.summary
FROM ticket LEFT JOIN ticket_change ON ticket.changetime = ticket_change.time
ORDER BY ticket.reporter, ticket.changetime desc
按照Ticket的reporter分组,并按changetime倒序排序。
显示了每个Ticket最后的修改人,现在分配给哪个人。比较实用。