[rt-users] relative data ticket search for monthly report?

[Kevin Falcone]

On Thu, Aug 04, 2011 at 01:29:53AM +0000, John Alberts wrote:
>    Hi.  I've found quite a few examples and documentation about using relative dates to search
>    RT; however, for the life of me, I can't figure out how to use relative dates to get a list of
>    tickets that were created last month.
>    I would like to create and save a search for our secretary, so she can easily get a list of
>    tickets in a specific queue that were created last month.  Without using relative dates,
>    getting the tickets in this queue that were created last month is not a problem.  This works
>    perfect.

We use the CPAN module Time::ParseDate, so you can use whatever syntax
it supports.
http://search.cpan.org/~muir/Time-modules-2011.0517/lib/Time/ParseDate.pm

-kevin

>    Queue = 'Root Cause Analysis Forms' AND (  Created >= '07-01-2011' AND Created < '08-01-2011'
>    )
>    Using relative dates, I tried these, and none work how I want.
>    # This works, but the end date isn't relative
>    Queue = 'Root Cause Analysis Forms' AND (  Created >= 'first of last month' AND Created <
>    '08-01-2011' )
>    # Returns 0 results
>    Queue = 'Root Cause Analysis Forms' AND (  Created >= 'first of last month' AND Created <
>    'first of this month' )
>    # Returns 0 results
>    Queue = 'Root Cause Analysis Forms' AND (  Created >= 'first of last month' AND Created <
>    'first of the month' )
>    # Returns 0 results
>    Queue = 'Root Cause Analysis Forms' AND (  Created >= 'first of last month' AND Created <
>    'this month' )
>    #Returns 0 results
>    Queue = 'Root Cause Analysis Forms' AND (  Created >= 'first of last month' AND Created <=
>    'end of last month' )
>    Any help appreciated.
>    Thanks
>    John

> 
> --------
> 2011 Training: http://bestpractical.com/services/training.html

-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 195 bytes
Desc: not available
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20110804/3980fb04/attachment.sig>