[rt-users] LastUpdated x days ago

[Kenneth Crocker]

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/ea5b5b07/attachment.htm>