A patch to add a $NOW dynamic variable to the reports

[gooli@…]

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.

[gooli@…]

patch file

[Matthew Good]

Searching for "$NOW" would've found ticket #2257 which provides a solution for doing date calculations in reports.