[rt-users] Ned help for RT ticketsql

[Jack Liu]

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


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20140107/6222e850/attachment.htm>