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 email@example.com wrote:
On Tue, 22 Feb 2005 08:15:50 +0000 (GMT), Oluwatomisin Ilori wrote:
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
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.
ALL-NEW Yahoo! Messenger - all new features - even more fun!