[Trac] Show all states the ticket has gone through

2009-06-23 Thread Sneha
Hi All, I want to create a report to display all states a ticket has gone through. Ex: Ticket 1 | new - assigned - closed - reopened - assigned I tried using following query to generate the result: select ticket,group_concat(newvalue) from ticket_change where field='status' It is working

[Trac] TimingAndEstimation reports

2009-06-23 Thread Mauricio Scheffer
I just installed the TimindAndEstimation plugin but none of the reports seem to be working. In the Ticket Hours report, I'm getting a ticket #0 as result (which doesn't exist, obviously), with Status Time Remaining: (sic), Summary Total and all the other fields as None. Other reports say No

[Trac] Re: TimingAndEstimation reports

2009-06-23 Thread Mauricio Scheffer
Never mind, sorry. On Jun 22, 6:48 pm, Mauricio Scheffer mauricioschef...@gmail.com wrote: I just installed the TimindAndEstimation plugin but none of the reports seem to be working. In the Ticket Hours report, I'm getting a ticket #0 as result (which doesn't exist, obviously), with Status

[Trac] change user email notification

2009-06-23 Thread Alex
Hi ! How can I edit user email with trac-admin utility or manually in sqlite database without edit preferences-email address? --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups Trac Users group. To post to this group,

[Trac] Re: Finding broken wiki links

2009-06-23 Thread Ice Polar
Hi, what about a SQL query directly on the database? What would be the problem? Ice --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups Trac Users group. To post to this group, send email to trac-users@googlegroups.com

[Trac] Re: change user email notification

2009-06-23 Thread Dan Winslow
I believe inserts into the session and session_attribute table will do the trick. -Original Message- From: trac-users@googlegroups.com [mailto:trac-us...@googlegroups.com] On Behalf Of Alex Sent: Tuesday, June 23, 2009 1:08 PM To: Trac Users Subject: [Trac] change user email notification