Edgewall Software

Opened 17 years ago

Closed 11 years ago

#2007 closed enhancement (worksforme)

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: Branch:
Release Notes:
API Changes:
Internal Changes:


Browsing tickets by date (eg. 10.08-20.08)

Attachments (0)

Change History (3)

comment:1 by Matthew Good, 17 years ago

Milestone: 1.0
Resolution: worksforme
Status: newclosed

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'

comment:2 by anonymous, 11 years ago

Resolution: worksforme
Status: closedreopened

This method doesn't work anymore. Date stored in database is no longer standard unix epoch value, but I can't find a difference.

comment:3 by Christian Boos, 11 years ago

Resolution: worksforme
Status: reopenedclosed

Please have a look at TracUpgrade#Microsecondtimestamps.

Modify Ticket

Change Properties
Set your email in Preferences
as closed The owner will remain daniel.
The resolution will be deleted. Next status will be 'reopened'.
to The owner will be changed from daniel to the specified user.

Add Comment

E-mail address and name can be saved in the Preferences .
Note: See TracTickets for help on using tickets.