[rt-users] LastUpdated for tickets not working?

Alex Hall ahall at autodist.com
Mon Dec 19 13:54:47 EST 2016


Hello all,
I'm trying to get stale ticket alerts working, so am using the
UntouchedInHours condition. I've also tried, in SQL:
LastUpdated <= '2 days ago'
and similar searches. Yet, I always get the same number of tickets as I get
when I leave the date restriction off completely, and UntouchedInHours is
always giving me tickets opened today.

Because the condition and my own query both rely on LastUpdated, I'm
starting to suspect that this field may not be working correctly. Is this a
know problem in 4.4.1, or--more probably--am I doing something wrong? I'm
not getting any errors anywhere, now that UntouchedInHours has been fixed
to use RT::Condition and not RT::Condition::Generic, but neither am I
getting the tickets I should be. Thanks for any ideas!

-- 
Alex Hall
Automatic Distributors, IT department
ahall at autodist.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20161219/2336083f/attachment.htm>


More information about the rt-users mailing list