Hi everyone,
Please, can anyone help me out with this. I’m trying to create a query string that can be used in rt-crontool to send timed notifications but i’m not getting the expected results.
The query string i’m using is:
Status != ‘resolved’ AND Created = ‘2 hours’ AND Queue = ‘InternetAccess’ . Actually, what i want is to be able to obtain tickets that have not been resolved in exactly 2 hours from the internet access queue, but my result is showing tickets that were created over 2 hours ago, like 12hours ago…Am i feeding in the wrong parameters? Please, any assistance would be greatly appreciated.
Thanks.
ALL-NEW Yahoo! Messenger - all new features - even more fun!
Hi everyone,
Please, can anyone help me out with this. I’m trying to create a query
string that can be used in rt-crontool to send timed notifications but i’m
not getting the expected results.
The query string i’m using is:
Status != ‘resolved’ AND Created = ‘2 hours’ AND Queue = ‘InternetAccess’
. Actually, what i want is to be able to obtain tickets that have not been
resolved in exactly 2 hours from the internet access queue, but my result is
showing tickets that were created over 2 hours ago, like 12hours ago…Am i
feeding in the wrong parameters? Please, any assistance would be greatly
appreciated.
Thanks.
If you specify Created = ‘2 hours’ then it’s going to look for tickets
that were created exactly 2 hours prior to the current time. Use
Created < ‘2 hours ago’ for your comparison.
Andy Harrison
Thanks Andy for the suggestion. The only problem with that is that i get tickets that were created even more than 2 hours ago from the current time- even those that had been created days and weeks ago were still displayed and that makes sense anyway. But what i really wanted is to get tickets that were created exactly 2 hours ago from the system time and i don’t get any accurate result. But I might have to make do with using <2 hours ago in the search string for now…Any further suggestions would be appreciated.
ThanksAndy Harrison aharrison@gmail.com wrote:
On Tue, 22 Feb 2005 08:15:50 +0000 (GMT), Oluwatomisin Ilori wrote:
Hi everyone,
Please, can anyone help me out with this. I’m trying to create a query
string that can be used in rt-crontool to send timed notifications but i’m
not getting the expected results.
The query string i’m using is:
Status != ‘resolved’ AND Created = ‘2 hours’ AND Queue = ‘InternetAccess’
. Actually, what i want is to be able to obtain tickets that have not been
resolved in exactly 2 hours from the internet access queue, but my result is
showing tickets that were created over 2 hours ago, like 12hours ago…Am i
feeding in the wrong parameters? Please, any assistance would be greatly
appreciated.
Thanks.
If you specify Created = ‘2 hours’ then it’s going to look for tickets
that were created exactly 2 hours prior to the current time. Use
Created < ‘2 hours ago’ for your comparison.
Andy Harrison
ALL-NEW Yahoo! Messenger - all new features - even more fun!
Thanks Andy for the suggestion. The only problem with that is that i get tickets that were created even more than 2 hours ago from the current time- even those that had been created days and weeks ago were still displayed and that makes sense anyway. But what i really wanted is to get tickets that were created exactly 2 hours ago from the system time and i don’t get any accurate result. But I might have to make do with using <2 hours ago in the search string for now…Any further suggestions would be appreciated.
Thanks
Exactly 2 hours ago means down to the second. Good luck with that!
-Todd
Thanks Andy for the suggestion. The only problem with that is that i get
tickets that were created even more than 2 hours ago from the current time-
even those that had been created days and weeks ago were still displayed and
that makes sense anyway. But what i really wanted is to get tickets that
were created exactly 2 hours ago from the system time and i don’t get any
accurate result. But I might have to make do with using <2 hours ago in the
search string for now…Any further suggestions would be appreciated.
Sorry, zigged when I should have zagged… That should be:
Created > ‘2 hours ago’
Andy Harrison