Current time

RT Developers
1

Hi all,

is there any variable i can use to check current time.

I would like to make a query like:

Query => " Owner = ‘CurrentUser’ AND ( started > ‘CurrentTime’ ) AND ( Status = ‘open’) AND (queue =‘test_queue’)",

But I dont know the right variable.
Actually what Im really interested in obtain is all tickets opened and not resolved for more than 20 days.

Any hints?

Thanks!

Alvaro Muñoz Sánchez

2

Hi all,

is there any variable i can use to check current time.

I would like to make a query like:

Query => " Owner = ‘CurrentUser’ AND ( started > ‘CurrentTime’ ) AND ( Status = ‘open’) AND (queue =‘test_queue’)",

But I dont know the right variable.
Actually what Im really interested in obtain is all tickets opened and not resolved for more than 20 days.

Please try

started > ‘20 days ago’

condition. Actually Date::Manip is used for date/time parsing, it recognizes almost any imaginable formats.

3

Thanks a lot, that did it!From: rt-devel-bounces@lists.bestpractical.com [mailto:rt-devel-bounces@lists.bestpractical.com] On Behalf Of Viktor
Sent: martes, 26 de junio de 2007 7:37
To: rt-devel@lists.bestpractical.com
Subject: Re: [Rt-devel] Current time

From: “Munoz, Alvaro” alvaro.munoz.sanchez@hp.com
To: rt-devel@lists.bestpractical.com
Date: Tue, 26 Jun 2007 00:00:12 +0200
Subject: [Rt-devel] Current time

Hi all,

is there any variable i can use to check current time.

I would like to make a query like:

Query => " Owner = ‘CurrentUser’ AND ( started > ‘CurrentTime’ ) AND ( Status = ‘open’) AND (queue =‘test_queue’)",

But I dont know the right variable.
Actually what Im really interested in obtain is all tickets opened and not resolved for more than 20 days.

Please try

started > ‘20 days ago’

condition. Actually Date::Manip is used for date/time parsing, it recognizes almost any imaginable formats.

Any hints?

Thanks!

Alvaro MuЯoz SАnchez

List info:
The rt-devel Archives

List info: The rt-devel Archives