Searches with variable dates

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

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:

http://search.cpan.org/~muir/Time-modules-2003.1126/lib/Time/ParseDate.pm

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)

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 http://wiki.bestpractical.com/index.cgi?SearchOnDates

http://search.cpan.org/~muir/Time-modules-2003.1126/lib/Time/ParseDate.pm

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 “<”.

-----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 http://wiki.bestpractical.com/index.cgi?SearchOnDates

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-----