In a SQL style report include "changetime AS modified" among the fields in the SELECT clause. Example:
-- ## 7: My Open Tickets ## -- -- All open tickets for current user. SELECT p.value AS __color__, (CASE status WHEN 'accepted' THEN 'Accepted' ELSE 'Owned' END) AS __group__, id AS ticket, summary, component, version, milestone, t.type AS type, priority, time AS created, changetime AS modified, description AS _description, reporter AS _reporter FROM ticket t LEFT JOIN enum p ON p.name = t.priority AND p.type = 'priority' WHERE t.status <> 'closed' AND owner = $USER ORDER BY (status = 'accepted') DESC, CAST(p.value AS int), milestone, t.type, time For Custom Query style reports, click on "> Columns" to open the list of the available columns, set the "Modified" check . -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Thomas Vriet Sent: Wednesday, July 15, 2009 12:48 PM To: [email protected] Subject: [Trac] Re: "last modified date" in tickets view more precisely what I'm looking for is : how I can make the ticket display page to have a "Modified" column, for instance this Trac do this : http://core.trac.wordpress.org/report/1 RJOllos wrote: > Sounds like you want to setup a custom query via the /query page. > > On Jul 7, 3:23 pm, Thomas Vriet <[email protected]> wrote: >> hello, >> >> how do I get a Trac to display a "last modified date" column in "View tickets" >> page. It seems to be possible as I saw it on other tracs. >> >> thanks and sorry if this is a trivial one but I didn't find any clue so far. >> >> cheers, >> >> Thomas > > > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
