Login | Register For Free | Help
Search for: (Advanced)

Mailing List Archive: Request Tracker: Devel

Current time

 

 

Request Tracker devel RSS feed   Index | Next | Previous | View Threaded


alvaro.munoz.sanchez at hp

Jun 25, 2007, 3:00 PM

Post #1 of 3 (469 views)
Permalink
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.

Any hints?

Thanks!

Alvaro Muñoz Sánchez


svitter at list

Jun 25, 2007, 10:37 PM

Post #2 of 3 (445 views)
Permalink
Re: Current time [In reply to]

-----Original Message-----
From: "Munoz, Alvaro" <alvaro.munoz.sanchez[at]hp.com>
To: <rt-devel[at]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: http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-devel
>
_______________________________________________
List info: http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-devel


alvaro.munoz.sanchez at hp

Jun 27, 2007, 6:37 AM

Post #3 of 3 (442 views)
Permalink
RE: Current time SOLVED [In reply to]

Thanks a lot, that did it!


-----Original Message-----
From: rt-devel-bounces[at]lists.bestpractical.com [mailto:rt-devel-bounces[at]lists.bestpractical.com] On Behalf Of Viktor
Sent: martes, 26 de junio de 2007 7:37
To: rt-devel[at]lists.bestpractical.com
Subject: Re: [Rt-devel] Current time



-----Original Message-----
From: "Munoz, Alvaro" <alvaro.munoz.sanchez[at]hp.com>
To: <rt-devel[at]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:
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-devel
>
_______________________________________________
List info: http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-devel
_______________________________________________
List info: http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-devel

Request Tracker devel RSS feed   Index | Next | Previous | View Threaded
 
 


Interested in having your list archived? Contact lists@gossamer-threads.com
 
  Web Applications & Managed Hosting Powered by Gossamer Threads Inc.