Ned help for RT ticketsql

Hi,

We are using RT 3.6.1. need create rt command line to find ticket created old than 3 hours ago. That should be easy as:
/usr/bin/rt list -t ticket " id=37679 and Created < ‘-180 minutes’ "
But the user need add some pending time to ignore, so I did try to create one custom field to record adjust start time
/usr/bin/rt list -t ticket " id=37679 and CF.{AdjustStart} < ‘-180 minutes’ "
But the problem is RT 3.6.1 didn’t support date type in custom field. So it is not working.
I also tried to put Pending ignore second in a field, but have no way to make this work for rt 3.6.1
/usr/bin/rt list -t ticket " id=37679 and Created < ‘-180 minutes’ + CF.{IgnoreTime} "

Please help.
Regards,
Jack

I also tried to put Pending ignore second in a field, but have no way to make this work for rt
3.6.1

/usr/bin/rt list -t ticket " id=37679 and Created < ‘-180 minutes’ + CF.{IgnoreTime} "

Are you trying to add the time from CF.IgnoreTime to the -180 minutes part?

You cannot do that in TicketSQL on any version of RT.

If you need to do that math, or ignore other things, you’re almost
certainly going to need to use RT’s perl API to write some Limits.
Documentation for newer versions of the API is available on

-kevin