[rt-users] LastUpdated x days ago

[Kenneth Crocker]

Matthew,

Opps. Acutally that's LastUpdated > '14 days ago'.

Kenn
LBNL

On Mon, Oct 11, 2010 at 9:48 AM, Kenneth Crocker <kfcrocker at lbl.gov> wrote:

> Matthew,
>
> We use "LastUpdated > '15 days ago' and it works fine. Every ticket updated
> 15 or more days ago gets in the report. Are there other criteria you forgot
> to mention?
>
> Kenn
> LBNL
>
>
> On Mon, Oct 11, 2010 at 2:27 AM, Raed El-Hames <Raed.El-Hames at vialtus.com>wrote:
>
>> Matthew;
>>
>> I 've used:
>> LastUpdated = '15 days ago'
>>
>> And it always worked for me.
>>
>> Regards;
>> Roy
>>
>> > -----Original Message-----
>> > From: rt-users-bounces at lists.bestpractical.com [mailto:rt-users-
>> > bounces at lists.bestpractical.com] On Behalf Of Mathew Snyder
>> > Sent: 11 October 2010 03:23
>> > To: RT Users
>> > Subject: [rt-users] LastUpdated x days ago
>> >
>> > I'm trying to write  a script that will check for tickets last updated
>> > 15 days ago. I'm using the FromSQL method. As far as I can tell, it
>> > doesn't like the '-15 days' or '15 days ago' options. If I use either
>> > one every ticket in the queue I'm searching in is returned. Am I
>> > doomed to perform a separate comparison for tickets last updated
>> > 1296000000 miliseconds ago or is there a more succinct way to do this?
>> >
>> > -Mathew
>> >
>> > RT Training in Washington DC, USA on Oct 25 & 26 2010
>> > Last one this year -- Learn how to get the most out of RT!
>>
>> RT Training in Washington DC, USA on Oct 25 & 26 2010
>> Last one this year -- Learn how to get the most out of RT!
>>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20101011/50217dcb/attachment.htm>