[rt-users] Generating querystrings from the web QueryBuilder

[Andy Harrison]

On Tue, 22 Feb 2005 08:15:50 +0000 (GMT), Oluwatomisin Ilori
<tomisilori at yahoo.co.uk> 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