<html dir="ltr">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=Windows-1252">
<style>
<!--
@font-face
{font-family:"Cambria Math"}
@font-face
{font-family:Tahoma}
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Tahoma","sans-serif"}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline}
span.EmailStyle17
{font-family:"Tahoma","sans-serif";
color:windowtext}
.MsoChpDefault
{font-family:"Tahoma","sans-serif"}
@page WordSection1
{margin:1.0in 1.0in 1.0in 1.0in}
-->
</style><style id="owaParaStyle" type="text/css">
<!--
p
{margin-top:0;
margin-bottom:0}
-->
</style>
</head>
<body vlink="purple" lang="EN-US" link="blue">
<div style="direction:ltr; font-family:Tahoma; color:#000000; font-size:10pt">LastUpdated <= '12 hours ago'<br>
<br>
<a href="http://requesttracker.wikia.com/wiki/TicketSQL#Date_Syntax" target="_blank">http://requesttracker.wikia.com/wiki/TicketSQL#Date_Syntax</a><br>
<br>
<br>
Regards<br>
<br>
<br>
<div style="font-family:Times New Roman; color:#000000; font-size:16px"><br>
<br>
<div align="left">
<p style="font-family:Calibri,Sans-Serif; font-size:10pt"><span style="color:#000000; font-weight:bold">Alberto Scotto</span>
<span style="color:#808080"></span><br>
<br>
<span style="color:#000000"><img border="0" alt="Blue" src="cid:9da3ace5620d4924b8063162f71c3379" style="margin:0px">
</span><br>
<span style="color:#808080">Via Cardinal Massaia, 83<br>
10147 - Torino - ITALY <br>
phone: +39 011 29100 <br>
<a href="al.scotto@reply.it" target="" style="color:blue; text-decoration:underline">al.scotto@reply.it</a>
<br>
<a title="" href="www.reply.it" target="" style="color:blue; text-decoration:underline">www.reply.it</a>
</span><br>
</p>
</div>
<hr tabindex="-1">
<div id="divRpF299334" style="direction:ltr"><font color="#000000" face="Tahoma" size="2"><b>Inizio:</b> rt-users-bounces@lists.bestpractical.com [rt-users-bounces@lists.bestpractical.com] per conto di Payam Poursaied [me@payam124.com]<br>
<b>Inviato:</b> domenica 8 luglio 2012 16.03<br>
<b>Fine:</b> rt-users@lists.bestpractical.com<br>
<b>Oggetto:</b> [rt-users] Time Calculation in Search Queries<br>
</font><br>
</div>
<div></div>
<div>
<div class="WordSection1">
<p class="MsoNormal">Hi all</p>
<p class="MsoNormal">One of my colleagues intended to get daily updates on tickets which has been not updated for past 12 hours.</p>
<p class="MsoNormal">I wrote a perl script and used REST interface. Then parse the output and based on the results, email him.</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">The web URL is something like below which I substitute date with current date-time minus 12 hours</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">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'</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">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”</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">is there any mechanism like this at all? </p>
</div>
</div>
</div>
</div>
<br>
<hr>
<font face="Arial" color="Gray" size="1"><br>
--<br>
The information transmitted is intended for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information
by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer.<br>
</font>
</body>
</html>