The information is stored in ticket_change table: select * from ticket_change where newvalue='closed' order by timestamp desc limit 0,5;
Does this help? Marjeta On Mar 1, 2:59 am, Ryan J Ollos <[email protected]> wrote: > Hello, > > I'm trying to create a list of tickets on my Trac homepage that shows > "Recently completed tickets". I'm using the following TicketQuery macro > arguments: > > [[TicketQuery(format=list, max=5, status=closed, resolution=fixed, > desc=True, order=changetime)]] > > The problem here is that, since I'm ordering by changetime, a ticket that is > updated after it is closed is bumped to the top of the list. I'd like to > order by the timestamp from when the ticket was closed. > > I seem to remember some discussion on this mailing list about the timestamps > for ticket transitions being stored in the DB, and I'm assuming the > discussion was about the ticket_change table [1]. > > Of course, if the value is not stored in the ticket table, then I can't see > how I could use the TicketQuery macro ... but could probably use the > WikiTable or SqlQuery macro. > > Any ideas of how I might accomplish this with just the TicketQuery macro? > > Any help is greatly appreciated. Thanks! > > [1]http://trac.edgewall.org/wiki/TracDev/DatabaseSchema > -- > View this message in > context:http://old.nabble.com/Use-timestamp-from-when-ticket-was-closed-in-Ti... > Sent from the Trac Users mailing list archive at Nabble.com. -- 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.
