Searches with variable dates

RT Users
1

Hi Everyone,

I wonder if anyone would be able to help.

Is it possible to compose a query with a variable date. For example:-

All calls where status=open and lastupdates <= 2 days ago (or maybe
TODAY-2). or are the searches limited to fixed dates.

I would like to have a saved search on my front screen that shows all
open calls that have not been updated in 2 days so that I can nag our
first/second line teams about them.

Thanks in advance

Regards

Lee

2

Lee W wrote:

All calls where status=open and lastupdates <= 2 days ago (or maybe
TODAY-2). or are the searches limited to fixed dates.

All date references go through the ParseDate PERL library, documented here:

Yes, you can use formalisms like:

Created > “-3 days”

  created more than 3 days ago

Due < “+2 days” AND
Due > “now”

  due date between now and 2 days from now

You can also use these date formats when you change the dates on an RT
ticket; e.g. if you enter the Due Date as “+10 days”, it will set the due
date to 10 days from now.

Rick R.

signature.asc (250 Bytes)

3

Rick Russell wrote:

Lee W wrote:

All calls where status=open and lastupdates <= 2 days ago (or maybe
TODAY-2). or are the searches limited to fixed dates.

All date references go through the ParseDate PERL library, documented here:
Documented Request Tracker Wiki

Time::ParseDate - date parsing both relative and absolute - metacpan.org

Yes, you can use formalisms like:

Created > “-3 days”

  created more than 3 days ago

I think here should be “less” instead of “more” or condition should be “<”.

4

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

++ 12/05/05 10:21 +0400 - Ruslan U. Zakirov:

All date references go through the ParseDate PERL library, documented here:
Documented Request Tracker Wiki

See also [1], where it already was documented in the Search section,
somewhere in middle of the entire page.

[1] http://wiki.bestpractical.com/index.cgi?ManualUsingWebInterface

Rejo Zenger rejo@rz.xs4all.nl - http://rejo.zenger.nl - PGP 0x75FC50F3
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.2 (GNU/Linux)

iD8DBQFCkM39Ha9Q5nX8UPMRAm44AJ9VVKz2HquClzVXi9ayvJEYi2MIDQCgzuIn
79JncCibr31kYyQ4OvK6NqY=
=nGro
-----END PGP SIGNATURE-----