Edgewall Software

Ticket #2007 (closed enhancement: worksforme)

Opened 3 years ago

Last modified 3 years ago

Allow to specify time intervals in reports

Reported by: ula Owned by: daniel
Priority: normal Milestone:
Component: report system Version: devel
Severity: major Keywords:
Cc:

Description

Browsing tickets by date (eg. 10.08-20.08)

Attachments

Change History

Changed 3 years ago by mgood

  • status changed from new to closed
  • resolution set to worksforme
  • milestone 1.0 deleted

Please see the SQLite documentation on date time functions for how to use them in your report.

Note that the Trac timestamps are in Unix format, so you can use a where clause like this for your example above:

where datetime(ticket.time, 'unixepoch')
    between '2005-08-10' and '2005-08-20'

Add/Change #2007 (Allow to specify time intervals in reports)

Author



Change Properties
<Author field>
Action
as closed
Next status will be 'reopened'
to The owner will change from daniel. Next status will be 'closed'
 
Note: See TracTickets for help on using tickets.