[rt-users] Time Calculation in Search Queries

[Payam Poursaied]

Hi all

One of my colleagues intended to get daily updates on tickets which has been
not updated for past 12 hours.

I wrote a perl script and used REST interface. Then parse the output and
based on the results, email him.

 

The web URL is something like below which I substitute date with current
date-time minus 12 hours

 

http://ticket/rt/REST/1.0/search/ticket?query=Queue = 'NOC-Voice' AND (
Status = 'new' OR Status = 'open' OR Status = 'stalled' ) AND LastUpdated <
'2012-6-8 16:51'

 

another way came to my mind but I could not completely implement it due to
time calculation. In the second way, I intended to create a search and put
it into dashboard and subscribe to that dashboard to have it each day in the
mailbox. The problem which I could  not figure it out, is how to do date
calculation in search query, i.e. something like "LastUpdated <= NOW() - 12
hours"

 

is there any mechanism like this at all? 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20120708/b76bf126/attachment.htm>