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-TicketQuery-macro-tp27739923p27739923.html 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.
