#3173: A patch to add a $NOW dynamic variable to the reports
-----------------------------+----------------------------------------------
Reporter: [EMAIL PROTECTED] | 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/>
_______________________________________________
Trac-Tickets mailing list
[email protected]
http://lists.edgewall.com/mailman/listinfo/trac-tickets
