[rt-users] LastUpdated x days ago

Ruslan Zakirov ruz at bestpractical.com
Mon Oct 11 15:26:27 EDT 2010


Hi.

LastUpdated > x means updated since x.  < means updated before x. So
LastUpdated < '15 days ago' is probably what you need and means tickets that
are not touched last 15 days.

Regards, Ruslan. From phone.
2010 10 11 20:49 пользователь "Kenneth Crocker" <kfcrocker at lbl.gov> написал:
> 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/de69e0d9/attachment.htm>


More information about the rt-users mailing list