实用的Trac Report查询

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最后的修改人，现在分配给哪个人。比较实用。