Nevermind, I tried this in testing on 4.2 and it didn't fix it. I was thinking
perhaps the human readable parsing was changing how the date was considered,
but it doesn't seem to be the case.
Aaron
> On Dec 19, 2016, at 3:16 PM, Aaron McCormack wrote:
>
> Alex, could it be an accidental reve
Alex, could it be an accidental reversal of > and < ?
I think LastUpdated >= '3 days ago' is more of the intent because you were
surprised of seeing tickets which were updated within the past day.
Aaron
> On Dec 19, 2016, at 12:32 PM, Alex Hall wrote:
>
> Well, I found something that works
On Dec 19, 2016, at 11:48 AM, Alex Hall
mailto:ah...@autodist.com>> wrote:
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:
/opt/rt4/bin/rt-crontool --search RT::Search::FromSQL \
--se
Well, I found something that works. It's not UntouchedInHours, but this
query seems to return what I want:
select id
from Tickets
where LastUpdated <= (now() - INTERVAL 10 DAYS);
I still have to work out how to email ticket owners, but at least I can get
the right tickets now. Odd that the other
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:
/opt/rt4/bin/rt-crontool --search RT::Search::FromSQL \
--search-arg "status != 'resolved' and LastUpdated <= '3 days ago'" \
--action RT::A
Hi Alex,
On Mon, Dec 19, 2016 at 12:54 PM, Alex Hall wrote:
> 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
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 UntouchedInHou