title: How to show due date column in the trac reports?
body: <p>I have <a href="http://trac.edgewall.org/" rel="nofollow">trac</a> installed for managing my online projects. I have also installed a date plugin <a href="http://trac-hacks.org/wiki/DateFieldPlugin" rel="nofollow">DateFieldPlugin</a> in it. I am unable to show this date filed in the custom reports.</p>
  
  <p>The following code generates the normal report.</p>
  
  <pre><code>SELECT p.value AS __color__,
  owner AS __group__,
  id AS ticket, severity, summary, component, milestone, t.type AS type, time AS created,
  changetime AS _changetime, description AS _description,reporter AS _reporter
  FROM ticket t
  LEFT JOIN enum p ON p.name = t.priority AND p.type = 'priority'
  WHERE status = 'assigned'
  ORDER BY owner, p.value, t.type, time
  </code></pre>
  
  <p>and I want something like this:</p>
  
  <pre><code>SELECT p.value AS __color__,
  owner AS __group__,
  id AS ticket, severity, summary, component, milestone, t.type AS type, time AS created,
  changetime AS _changetime, description AS _description,
  reporter AS _reporter, c.value AS Duedate
  FROM ticket t
  LEFT JOIN enum p ON p.name = t.priority AND p.type = 'priority', ticket_custom c
  WHERE status = 'assigned'
  ORDER BY owner, p.value, t.type, time
  </code></pre>
  
  <p>The above code is showing me the due date column though it is showing one task row as multiple times.</p>
  
  <p>Can anybody help me in this?</p>