Another way of doing is to add a closedate field to the ticket table and put a trigger on the ticket_change table. Then you can get all your info from the ticket table.
On Mar 1, 3:27 pm, RjOllos <[email protected]> wrote: > On Mar 1, 8:48 am, MC <[email protected]> wrote: > > > 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? > > Yes, thank you. I'll give it a try ... the only catch is that I can't > see a way to do this with the TicketQuery macro, so I guess I'll have > to use the SqlQuery macro. -- 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.
