[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
Re: [rt-users] search by today
Garry: Try: Created < 'now' AND Created > '2 week ago' AND Queue = 'FOO' Roy > -Original Message- > From: rt-users-boun...@lists.bestpractical.com [mailto:rt-users- > boun...@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
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-ha...@daisygroupplc.com> wrote: > Garry: > > Try: > Created < 'now' AND Created > '2 week ago' AND Queue = 'FOO' > > Roy > > > -Original Message- > > From: rt-users-boun...@lists.bestpractical.com [mailto:rt-users- > > boun...@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 >
Re: [rt-users] search by today
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-boun...@lists.bestpractical.com [mailto:rt-users-boun...@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 On Tue, Apr 5, 2011 at 8:28 AM, Raed El-Hames mailto:raed.el-ha...@daisygroupplc.com>> wrote: Garry: Try: Created < 'now' AND Created > '2 week ago' AND Queue = 'FOO' Roy > -Original Message- > From: > rt-users-boun...@lists.bestpractical.com<mailto:rt-users-boun...@lists.bestpractical.com> > [mailto:rt-users-<mailto:rt-users-> > boun...@lists.bestpractical.com<mailto:boun...@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
Re: [rt-users] search by today
On Tue, Apr 5, 2011 at 7:04 PM, Garry Booth wrote: > 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.
Re: [rt-users] search by today
On 5 Apr 2011, at 22:07, Ruslan Zakirov wrote: http://requesttracker.wikia.com/wiki/SearchOnDates Hi Many thanks for all of the tips, this one did the job. regards garry