Hi, We have SQL query for reports: ===
SELECT p.value AS __color__, owner AS __group__, id AS ticket, severity,priority, status, 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' OR status = 'new' ORDER BY owner, p.value, t.type, time === We need to add one more column to this : Due Date How would you modify the query to support this? -- You received this message because you are subscribed to the Google Groups "Trac Users" group. To view this discussion on the web visit https://groups.google.com/d/msg/trac-users/-/G7R6au855yQJ. To post to this group, send email to trac-users@googlegroups.com. To unsubscribe from this group, send email to trac-users+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/trac-users?hl=en.