[rt-users] Generating querystrings from the web QueryBuilder

[Oluwatomisin Ilori]

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

 
 

Andy Harrison <aharrison at 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!  
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20050223/425dcf39/attachment.htm>