[rt-users] search by today

[Raed El-Hames]

Yep, you are right Kenn.
I was translating the original query, your "Created > '2 weeks ago' " will be more efficient. - I think

Roy

From: rt-users-bounces at lists.bestpractical.com [mailto:rt-users-bounces at lists.bestpractical.com] On Behalf Of Kenneth Crocker
Sent: 05 April 2011 17:39
To: rt-users at lists.bestpractical.com
Subject: Re: [rt-users] search by today

Raed,

Isn't the "now" kind of intuitive? Wouldn't "Created > '2 weeks ago' work just as well since the query is already running 'Today' or realtime? Unless you can created dates in the future, but I would think that unlikely. Just a theological thought, ;-).

Kenn
LBNL
On Tue, Apr 5, 2011 at 8:28 AM, Raed El-Hames <Raed.El-Hames at daisygroupplc.com<mailto:Raed.El-Hames at daisygroupplc.com>> wrote:
Garry:

Try:
Created < 'now' AND Created > '2 week ago' AND Queue = 'FOO'

Roy

> -----Original Message-----
> From: rt-users-bounces at lists.bestpractical.com<mailto:rt-users-bounces at lists.bestpractical.com> [mailto:rt-users-<mailto:rt-users->
> bounces at lists.bestpractical.com<mailto:bounces at lists.bestpractical.com>] On Behalf Of Garry Booth
> Sent: 05 April 2011 16:05
> To: RT Users
> Subject: [rt-users] search by today
>
> Hi All
>
> does anybody know if there is a way to dynamically search through
> tickets with creation dates from today to two weeks ago, without
> changing the dates every time?
>
> e.g. Created < 'NOW' AND Created > 'NOW -13' AND Queue = 'FOO'
>
> regards
>
> Garry

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20110405/1a97c8c2/attachment.htm>