<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class="">
<br class="">
<div>
<blockquote type="cite" class="">
<div class="">On Dec 19, 2016, at 11:48 AM, Alex Hall <<a href="mailto:ahall@autodist.com" class="">ahall@autodist.com</a>> wrote:</div>
<br class="Apple-interchange-newline">
<div class="">
<div dir="ltr" class="">
<div class="">
<div class="">
<div class="">
<div class="">
<div class="">
<div class="">
<div class="">
<div class="">
<div class="">
<div class="">
<div class="">
<div class="">
<div class="">
<div class="">
<div class="">
<div class="">
<div class="">
<div class="">I'm using the Crontool, yes, but I've also been doing searches on the web interface to see if I could get this to work. My Crontool syntax is something like:<br class="">
<br class="">
</div>
/opt/rt4/bin/rt-crontool --search RT::Search::FromSQL \<br class="">
</div>
--search-arg "status != 'resolved' and LastUpdated <= '3 days ago'" \<br class="">
</div>
--action RT::Action \<br class="">
</div>
--verbose<br class="">
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</blockquote>
<div><br class="">
</div>
<div><br class="">
</div>
<div>LastUpdated can change for nearly any change to the ticket if that change is recorded (ie. RecordTransaction => 1) like a Status change or an update to the watchers etc. The one you might want to use instead is LastTold which, to my knowledge, is when
the last correspondence was made. I may be mistaken here though but I think that's what LastTold is for. Try using LastTold instead of LastUpdated.</div>
<br class="">
<blockquote type="cite" class="">
<div class="">
<div dir="ltr" class="">
<div class="">
<div class="">
<div class="">
<div class="">
<div class="">
<div class="">I'm in the database now, looking at the Tickets table and messing with queries. I just tried this, but got an empty set:<br class="">
<br class="">
</div>
select id, LastUpdated from Tickets where LastUpdated <= '3 days ago' order by LastUpdated DESC limit 10;</div>
</div>
</div>
</div>
<br class="">
</div>
I'm not surprised I got nothing, as I imagine the '3 days ago' syntax is something RT interprets before giving the query to the database engine. Still, it was worth a shot. I'm now refreshing my knowledge of date math in MySQL so I can query exactly what I
want, but I hoped UntouchedInHours would do all that for me. Oh, and yes, LastUpdated does seem to have normal values in it.
</div>
</div>
</blockquote>
<div><br class="">
</div>
<div>Yes - '3 days ago' is interpreted specially by a module used by RT for things like rt-crontool and the search UI within RT. MySQL has no idea how to interpret that though so it won't work there.</div>
<div><br class="">
</div>
<div>
<div>
<blockquote type="cite" class="">
<div dir="ltr" class="">They're in GMT time, but they seem to be correct.<br class="">
</div>
</blockquote>
<div><br class="">
</div>
<div>All date/time values stored by MySQL are GMT. One must convert them to GMT before storage and convert them to the user's timezone when displaying them. RT is aware of this and already takes care of it assuming your time zone settings are correct on the
server.</div>
<div class=""><br class="">
</div>
</div>
</div>
</div>
<div class="">
<div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class="">
<div style="color: rgb(0, 0, 0); font-family: Helvetica; font-size: 18px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px;">
--<br class="">
Landon Stewart<br class="">
Lead Analyst - Abuse and Security Management<br class="">
INTERNAP ®<br class="">
📧 <a href="mailto:lstewart@internap.com" class="">lstewart@internap.com</a><br class="">
🌍 <a href="http://www.internap.com" class="">www.internap.com</a></div>
</div>
</div>
<br class="">
</body>
</html>