[rt-users] rt-crontool, find unanswered tickets

[Andrea Zimmerli]

Hi,

I wish to setup the rt-crontool (RT 3.6.17) to find tickets not
acknowledged
after 6 hours by using the "Told" field.

I am not able to select those ticket because the value of the Told field is
"Not set".

I've tried using '1970-01-01 00:00:00' but it does not work.
/opt/rt3/bin/rt-crontool --search RT::Search::FromSQL --search-arg "Queue =
'network' AND (Status = 'new' OR Status = 'open') AND Told <= '1970-01-01
00:00:00'" --action RT::Action::Generic --verbose

How can I look for tickets that have not been answered?

Thanks for helping me.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20140317/89051742/attachment.htm>