$NOW dynamic variable

[anonymous]

Hello,

for some reports I use I have found useful to be able to filter according to a given timeframe (e.g. tickets submitted in last 2 hours)

On my local copy I managed it with following changes in trac/ticket/report.py

[line 22, add following line]

import time

[line 442, at the end of the function get_var_args add the following code]

if not report_args.has_key('NOW'):
    report_args['NOW'] = int(time.time())

[sid]

Each database already has this type of thing as part of its standard SQL language.

For example, in SQLite, you can use:

SELECT date('now');

In MySQL, you can use:

CURDATE()
CURRENT_TIME()

Propose to close as wontfix