Use the View Tickets menu. You will see a 'create report' option. If you want to edit an existing report, select it for viewing. If you have admin rights you will see a 'edit report' button. Both create and edit options give you an edit box you can type in. The SQL itself is stored in the 'report' database table. You can use the date-time functions in SQL to limit the selection date based on the database columns 'time' and/or 'changetime'.
________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of Alejandro Mussi Sent: Wednesday, June 24, 2009 3:21 AM To: [email protected] Subject: [Trac] Re: Show Closed Tickets from a certain date Thanks Vela, i have installed the plug-in, but it seems it only add a due date when creating a new ticket (which it is good), but what i really need is to change some reports in order to get a list of closed tickets from a specific date. Where is hosted the reports files which their sql??, i would like to add some reports but i do not where to put the sql query. Thanks On Mon, Jun 22, 2009 at 7:07 AM, velappan velappan <[email protected]> wrote: Hi Alex, This thing you can attain by using this plugin http://trac-hacks.org/wiki/DateFieldPlugin. With basic options in trac you can see the reports based on the date. Regards Vela.Velappan On Jun 19, 11:30 pm, Alex M <[email protected]> wrote: > Hi all, I would like to see closed tickets from a specific date. How > can I add this report to the existing ones? > Thanks -- --------------------------------------------------------- Alejandro Mussi Campos Cervera --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
