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

[John Alberts]

I know, and I looked at the docs, but I can't figure out how to do what I
want.  I figured someone on the list must have figured out a way to get
last months report easily, regardless of how long it is into the current
month.

After spending more time on this, it turns out Created >= 'first of last
month' doesn't work either.  It's not documented to work, but it did
return the results I expected.  I found out the only reason it did, was
because there are no tickets in the queue I queried older than a month
anyway. :)

The problem is, I can't figure out if it's possible to combine a relative
date with other criterion.  For instance, 'last month' returns exactly one
month ago, so since today is Aug 4th, it returns July 4th, although I need
July 1st @midnight.

Any ideas?



----------
John Alberts
Cloud Optimization Engineer
Ex Libris (USA) Inc.
1350 E. Touhy Ave.  Suite 200 East
Des Plaines, IL 60018
Phone: 1-219-979-6560
 
Follow Ex Libris on Twitter: @exlibrisgroup
<http://twitter.com/ExLibrisGroup>





On 8/4/11 9:42 AM, "Kevin Falcone" <falcone at bestpractical.com> wrote:

>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
>
>
>--------
>2011 Training: http://bestpractical.com/services/training.html