Add search parameter to find tickets by a number of days old

I would like ot be able to create a saved search that I can use to generate
a report for Tickets that are “x” days old. It seems like a logical thing to
do, but the only way I can find to do it is to manually specify a date in
the “Add Criteria” “Created” field. I would like a field that allows me to
specify and save:

“Created”, “before/on/after”, “____ Days Ago”

I tried hacking the code, but I will admit that I am still a little weak
with the Mason/HTML programming.
If something like this already exists, if someone can please point me in the
right direction, I would appreciate it.

Mark P. Fraser

I would like ot be able to create a saved search that I can use to generate
a report for Tickets that are “x” days old.

On the search form, just enter “3 days ago” for the date. E.g.,

[Created] [Before] [3 days ago]

The resulting query is:

Created < ‘3 days ago’

Works great.

Lars Kellogg-Stedman lars@oddbit.com

http://wiki.bestpractical.com/view/SearchOnDatesOn Sat, Nov 8, 2008 at 4:42 PM, Mark Fraser mpfraser@ndshq.com wrote:

I would like ot be able to create a saved search that I can use to generate
a report for Tickets that are “x” days old. It seems like a logical thing to
do, but the only way I can find to do it is to manually specify a date in
the “Add Criteria” “Created” field. I would like a field that allows me to
specify and save:

“Created”, “before/on/after”, “____ Days Ago”

I tried hacking the code, but I will admit that I am still a little weak
with the Mason/HTML programming.
If something like this already exists, if someone can please point me in the
right direction, I would appreciate it.


Mark P. Fraser


http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

Best regards, Ruslan.