[Trac-tickets] [The Trac Project] #1075: Add default report listing tickets by modified date/time (descending)

[The Trac Project]

#1075: Add default report listing tickets by modified date/time (descending)
-------------------------+--------------------------------------------------
       Id:  1075         |      Status:  new                     
Component:  general      |    Modified:  Tue Dec 21 08:55:34 2004
 Severity:  enhancement  |   Milestone:                          
 Priority:  low          |     Version:  0.8                     
    Owner:  jonas        |    Reporter:  Manuzhai                
-------------------------+--------------------------------------------------
 Think that would be useful, especially as long not all ticket changes are
 shown on the timeline. Query below.

 SELECT p.value AS __color__,
    id AS ticket, summary, component, version, milestone, severity,
    (CASE status WHEN 'assigned' THEN owner||' *' ELSE owner END) AS owner,
    time AS created,
    changetime AS _changetime, description AS _description,
    reporter AS _reporter
   FROM ticket t, enum p
   WHERE status IN ('new', 'assigned', 'reopened')
 AND p.name = t.priority AND p.type = 'priority'
   ORDER BY t.changetime DESC, p.value, milestone, severity, time

-- 
Ticket URL: <http://projects.edgewall.com/trac/ticket/1075>
The Trac Project <>