[Trac-tickets] [The Trac Project] #1148: How to include changelog in ticket reports?

[The Trac Project]

#1148: How to include changelog in ticket reports?
---------------------------+------------------------------------------------
       Id:  1148           |      Status:  new                          
Component:  report system  |    Modified:  Thu Jan 20 04:55:08 2005     
 Severity:  normal         |   Milestone:                               
 Priority:  normal         |     Version:  0.8                          
    Owner:  daniel         |    Reporter:  p.schregle at impuls-imaging.com
---------------------------+------------------------------------------------
 I want to create a ticket report that includes the full description as
 well as the changelog of a ticket.

 I've tried the following report syntax:

 {{{
 SELECT p.value AS __color__,
    t.milestone AS __group__,
    (CASE status
       WHEN 'closed' THEN 'color: #777; background: #ddd; border-color:
 #ccc;'
       ELSE
         (CASE owner WHEN '$USER' THEN 'font-weight: bold' END)
     END) AS __style__,
    id AS ticket, summary, component, status,
    resolution,version, severity, priority, owner,
    changetime AS modified,
    time AS _time,reporter AS _reporter,
    description AS _description_
   FROM ticket t,enum p
   WHERE p.name=t.priority AND p.type='priority'
   ORDER BY (milestone IS NULL), milestone DESC, (status = 'closed'),
         (CASE status WHEN 'closed' THEN modified ELSE -p.value END) DESC

 }}}

 which works as I'd like it but does only include the ticket description
 originally provided with the ticket, not the changes made to the ticket
 afterwards.

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