That was just what i needed!! Thank you so much Ryan! =D
El miércoles, 29 de junio de 2016, 22:46:13 (UTC-3), RjOllos escribió: > > > > On Wednesday, June 29, 2016 at 8:14:45 AM UTC-7, [email protected] > <javascript:> wrote: >> >> Hi everyone, >> >> I have a lot of closed tickets that have the owner field in blank. So >> what i want to know is who was the last user that modify each of those >> tickets, so i can assign them as "owners". >> Is there a way to generate some kind of report for this? Im new with this >> tool, and im not familiarized with the query language yet. >> >> Hope I made clear my problem. >> >> Thanks in advance. >> >> Esteban >> > > The author of the last comment isn't available using a Custom Query, but > you could write a Report with SQL to provide the information. > > The SQL for a report that shows the author of the last comment for closed > tickets is: > > > SELECT id, summary, tc.author, changetime AS modified, MAX(tc.time) AS > _latest > > FROM ticket t, ticket_change tc > > WHERE t.id = tc.ticket > > AND status = 'closed' > > GROUP BY t.id > > > > You can also add a "set owner" action to the closed state of your > workflow. Here is a snippet we use on trac.edgewall.org: > > change_owner = assigned,closed -> * > > change_owner.name = change ownership > > change_owner.operations = set_owner > > change_owner.permissions = TICKET_MODIFY > > > - Ryan > > > -- You received this message because you are subscribed to the Google Groups "Trac Users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/trac-users. For more options, visit https://groups.google.com/d/optout.
