On Wed, 2009-06-17 at 07:26 -0700, yoheeb wrote: > On Jun 17, 2:59 am, Chris Carr <[email protected]> wrote: > > Originally sent to the trac-hacks users ML, which seems to have no > > traffic, so re-sending here. Grateful for any thoughts on how to do this > > and whether it's already been done: > > > > On Sat, 2009-06-13 at 11:11 +0100, Chris Carr wrote: > > > Hi all, > > > > > I'm looking to add a custom "Last Modified By" field to Trac tickets, > > > which is automatically populated with the $USER of the last person to > > > comment on or modify the ticket. Before I started, I thought I would see > > > if anything similar was out there. I've looked on trac-hacks, and I > > > can't see anything related except the CustomFieldAdmin and > > > CustomFieldProvider plugins. Does anyone know whether what I want has > > > already been done, either by using these plugins or some other way? > > > > > (I've also looked at trac.edgewall.org but I can't see any tickets about > > > this there. When I asked in #8371 I got pointed towards custom fields, > > > hence my assumption that it could be done that way.) > > > > > Grateful for any thoughts - is it worth putting this on Request-a-hack? > > > > > Regards, > > > > > CC > > This information is already available in the ticket history. Really > it's just a matter of extracting this information for reporting > purposes (I assume) since it is displayed in the ticket history. Some > SQL-fu should probably take care of what you are after. I, > unfortunately, and an SQL nit-wit. But I am sure someone can answer > it. if it hasn't already been shown somewhere in this user group. > > also, if it's just a viewing issue, and you really don't want to > scroll to the bottom of hte ticket change history, you can click on > the link in Last Change xMonths ago > which will take you to the timeline, and highlight the particular > change in question, which also shows the whom in this equation. > > Just some thoughts.
Thanks. I should have said first time around - I'm aware that the information can be extracted by SQL-fu, e.g. using the Reports module. What I want to do is be able to see it using the Query module (because the reports module is deprecated according to trac.edgewall.org/wiki/TracReports). In the Query module, I want to be able to select Last Modified By as a filter (e.g. to filter out tickets last modified by me), and I want to be able to show Last Modified By as a column. I'd be grateful to know if anyone has done either of these things in the Query module, and if so how. Many thanks, Chris --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
