[Trac-tickets] [The Trac Project] #3173: A patch to add a $NOW dynamic variable to the reports

[The Trac Project]

#3173: A patch to add a $NOW dynamic variable to the reports
-----------------------------+----------------------------------------------
 Reporter:  gooli at tuzig.com  |       Owner:  daniel
     Type:  enhancement      |      Status:  new   
 Priority:  normal           |   Milestone:        
Component:  report system    |     Version:  0.9.4 
 Severity:  normal           |    Keywords:        
-----------------------------+----------------------------------------------
 I wanted to create a report that shows the tickets closed in the last 7
 days, but couldn't find a way to do that. So I added the $NOW dynamic
 variable that has the value of int(time.time()).

 It is now possible to use reports such as this one (that get's the tickets
 that have been closed in the last 7 days):

 SELECT
    id AS ticket,
    summary,
    changetime AS modified
 FROM ticket
 WHERE $NOW - changetime < 7*24*60*60 AND status = 'closed'

 The patch is against 0.9.4 and it applied to the tickets/report.py file in
 the get_var_args function.

-- 
Ticket URL: <http://projects.edgewall.com/trac/ticket/3173>
The Trac Project <http://trac.edgewall.com/>