#3510: Query module lacks date/time features
----------------------------------+-----------------------------------------
Reporter: [EMAIL PROTECTED] | Owner: jonas
Type: enhancement | Status: new
Priority: normal | Milestone:
Component: general | Version: 0.9.6
Severity: minor | Keywords:
----------------------------------+-----------------------------------------
TracReports encourages me to see what I can do with reports but not query,
so I did.
One of our reports is "Tickets closed within the last 30 days, by owner."
It's handy for making monthly status reports and other bureaucratic
nonsense. We're accomplishing the closed date in SQL like so:
{{{ status = 'closed' AND changetime > (strftime('%%s', 'now') - (60 * 60
* 24 * 30)) }}}
As far as I can tell, there is no way to accomplish this with the query
module, as it provides no access to the dates at all, not to mention
comparison to values that change.
As per a way to add it? Well, it's complicated, so I don't know ... but
it is definitely a feature not occuring in the query module (at least in
0.9.6). Perhaps access to the timestamps directly, a variable for the
current time, and some simple math, but that wouldn't be intuitive at all
to people unoccustomed to UNIX timestamps.
--
Ticket URL: <http://trac.edgewall.org/ticket/3510>
The Trac Project <http://trac.edgewall.com/>
_______________________________________________
Trac-Tickets mailing list
[email protected]
http://lists.edgewall.com/mailman/listinfo/trac-tickets
