show today's closed tickets in Trac wiki using ticketquery

1.3k Views Asked by At

I would like to show using Ticketquery all closed tickets for the day only. I have the following query '[[TicketQuery(status=closed,owner=rrwithro|dmorales|hcpatel|pwmitche|adboatne|dbadmin,group=owner,order=priority,format=table,col=id|summary|priority|changetime)]]'

Whenever i put in changetime i get an integer error "".

2

There are 2 best solutions below

3
On

That macro works fine in my Trac (after changing the user names, of course). What version of Trac are you running?

Does the Trac log show anything useful? If not, try increasing the log level to 'DEBUG' and see if any details get printed out.

Disable some or all of your Trac plugins and see if the behavior changes. It is possible that the error might be originating from one of them.

Also, does that query work in the normal ticket query interface (not the macro)? If so, you can save the query there and refer to it by number.

0
On

You want to see tickets closed today only, right? Then limiting the changetime should work with the following syntax: [[TicketQuery(status=closed,owner=rrwithro|dmorales|hcpatel|pwmitche|adboatne|dbadmin,group=owner,changetime=today;now,order=priority,format=table,col=id|summary|priority|changetime)]]

But this is for Trac0.12 only, sorry.

Since 0.12, the date fields `created` and `modified` can be constrained by using the `=` operator and specifying a value containing two dates separated by a semicolon (';').

This has been changed later to "two dates separated by two dots ('..')"