Edgewall Software
Modify ↓

Ticket #2007 (closed enhancement: worksforme)

Opened 6 years ago

Last modified 11 months 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:
Release Notes:
API Changes:

Description

Browsing tickets by date (eg. 10.08-20.08)

Attachments

Change History

comment:1 Changed 6 years ago by mgood

  • Milestone 1.0 deleted
  • Resolution set to worksforme
  • Status changed from new to closed

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 Changed 11 months ago by anonymous

  • Resolution worksforme deleted
  • Status changed from closed to reopened

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 Changed 11 months ago by cboos

  • Resolution set to worksforme
  • Status changed from reopened to closed

Please have a look at TracUpgrade#Microsecondtimestamps.

View ↑

Add a comment

Modify Ticket

Change Properties
<Author field>
Action
as closed
The resolution will be deleted. Next status will be 'reopened'
to The owner will be changed from daniel. Next status will be 'closed'
Author


E-mail address and user name can be saved in the Preferences.

Attachments ↑
 
Note: See TracTickets for help on using tickets.