Hi Robert, which times would you consider on the queries ? The time the user accepted and closed the ticket ?
Beware that a ticket can be reopened and opened / closed more than once and by different users. If you find a good solution to your need, please post here. I'm also interested on getting this automatically. Cheers, LEslie On Tue, Jun 5, 2012 at 9:19 AM, Marucha <[email protected]> wrote: > > Hi Leslie, > > I've read about this plugin but first I'd do this by a query, and secondly, > using this plugin user have to manually enter the time, and I need time > saved automatically in Trac. > > Robert > > > > Leslie Watter-2 wrote: > > > > Hi Robert, > > > > Did you've tried TracHoursPlugin ? > > I'm using it here and every time a developer works on a ticket it assigns > > the time worked. It's easy to get a report on what ticket who are working > > or worked. > > > > You can find TracHoursPlugin at trac-hacks.org > > > > Cheers, > > > > LEslie > > > > On Tue, Jun 5, 2012 at 7:52 AM, Marucha <[email protected]> wrote: > > > >> > >> Hi, > >> I'm a new user of trac. What I need to do is to find a query to get how > >> much > >> time each ticket spent assigned to one user? > >> I've tried to use some sqlite queries but any of my result didn't > satisfy > >> me. > >> > >> I will be grateful for any tips > >> > >> Robert > >> > >> -- > >> View this message in context: > >> http://old.nabble.com/Time-report-tp33963287p33963287.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. > >> > >> > > > > > > -- > > Leslie H. Watter > > > > -- > > 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. > > > > > > > -- > View this message in context: > http://old.nabble.com/Time-report-tp33963287p33963707.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. > > -- Leslie H. Watter -- 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.
