I've modified the standard report 1 to also show when comments were made
to a ticket. The following is the SQL statement I'm using:
SELECT p.value AS __color__,
id AS ticket, summary, component, version, milestone, t.type AS type,
(CASE status WHEN 'assigned' THEN owner||' *' ELSE owner END) AS owner,
t.time AS created, tc.time AS updated
FROM ticket t
LEFT JOIN enum p ON p.name = t.priority AND p.type = 'priority'
LEFT JOIN ticket_change tc ON tc.field = 'comment' and tc.ticket = t.id
WHERE status IN ('new', 'assigned', 'reopened')
ORDER BY p.value, milestone, t.type, t.time
The "updated" column does not show as a date as I would like it to, it
only shows up as an integer. How do I get Trac to do this? We are
running 10.3.
Thanks
-Andrew
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Trac
Users" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/trac-users?hl=en
-~----------~----~----~----~------~----~------~--~---
