On Wednesday, June 29, 2016 at 8:14:45 AM UTC-7, [email protected] 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.
