[rt-users] Report for Tickets Resolved "Last Month"

Ole Craig ocraig at stillsecure.com
Fri Jun 22 13:06:07 EDT 2007

    I needed something similar for "<day of week> before last" so that I
could say "show me all tickets where ("resolved > Sunday before last"
and "resolved < last Sunday") to get at tickets resolved last week,
regardless of what day I ran the search. (My Mondays are not generally
conducive to quiet reflection on the previous week's activity. :-)

    I ended up hacking the necessary into Time::ParseDate, which is what
RT uses to parse out "natural language" dates. It was actually a pretty
simple change; the diff was about 15 lines. Dave Sharnoff (the package
author) was kind enough to accept a patch at some point so it's now part
of the stock Time::ParseDate. 

    Perhaps you could look at doing something similar: adding semantics
for "this month", "last month", and "next month" to return a date entity
corresponding to 00:00:01 on the 1st of the appropriate month?


On Thu, 2007-06-21 at 18:30 -0600, Samuel P. Howard wrote:
> Hi.
> I know that RT can use some natural language description of dates, but I 
> haven't found any combination that seems to work to give me a report of 
> all tickets resolved "last month".
> Ideally, it would be last month, the whole month, not 30 days ago (or 
> else, we could really only run the report on 1 day of the month and get 
> the report we need).
> Any suggestions?
> Thanks,
> Sam
> _______________________________________________
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
> Community help: http://wiki.bestpractical.com
> Commercial support: sales at bestpractical.com
> Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
> Buy a copy at http://rtbook.bestpractical.com
/Ole Craig
Security Engineer
Team lead, customer support

ocraig at stillsecure.com
303-381-3824 direct
303-381-3802 support
303-381-3880 fax


More information about the rt-users mailing list