Not Updated called in x Days

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

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.

Whether or not this will work depends on the context in which you’re
working, but if it’s in a context where you can embed perl code, you
can make a call to time() to get the current epoch, and work from there.

Two Days Ago == { time() - (606024) }

Matt Pounsett

PGP.sig (186 Bytes)

3

Two Days Ago == { time() - (606024) }

Er… that should be { time() - (606024*2) }, but I think you got
the idea.

Matt

PGP.sig (186 Bytes)