Search by today

RT Users
1

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

2

Garry:

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

Roy

3

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
LBNLOn Tue, Apr 5, 2011 at 8:28 AM, Raed El-Hames < Raed.El-Hames@daisygroupplc.com> wrote:

Garry:

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

Roy

-----Original Message-----
From: rt-users-bounces@lists.bestpractical.com [mailto:rt-users-
bounces@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

4

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

RoyFrom: rt-users-bounces@lists.bestpractical.com [mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Kenneth Crocker
Sent: 05 April 2011 17:39
To: rt-users@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

Garry:

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

Roy

-----Original Message-----
From: rt-users-bounces@lists.bestpractical.commailto:rt-users-bounces@lists.bestpractical.com [mailto:rt-users-mailto:rt-users-
bounces@lists.bestpractical.commailto:bounces@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

5

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’

For future references, it’s on wiki:

http://requesttracker.wikia.com/wiki/SearchOnDates

regards
Garry

Best regards, Ruslan.

6

http://requesttracker.wikia.com/wiki/SearchOnDates

Hi

Many thanks for all of the tips, this one did the job.

regards
garry