[rt-users] Ned help for RT ticketsql

[Kevin Falcone]

On Tue, Jan 07, 2014 at 12:46:24PM -0500, Jack Liu wrote:
> 
>    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
http://docs.bestpractical.com

-kevin
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 235 bytes
Desc: not available
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20140107/ae08b614/attachment.sig>