On Sun, Aug 11, 2013 at 09:23:32AM +0200, Joop wrote:
> Landon wrote:
>
> Sorry for hijacking your question/thread.
>
> Is there any way to search for tickets while comparing two field values?
> This doesn't work:
> Queue = 'Incident Reports' AND Created < CF.{SpecialDate} AND Status =
> 'new'
> It doesn't like the string "CF.{SpecialDate}" because it's not enclosed
> in quotations and
> therefor not a string. Which is what I want to do but cannot I guess.
> The error displayed
> on the RT UI is:
>
> Wrong query, expecting a VALUE in 'Queue = 'Incident Reports' AND
> Created <
> >CF.{SpecialDate}<--here AND Status = 'new''
>
> I'm looking at something similar. I would like to check whether the
> ResolvedDate is past the
> DueDate but that is also not possible. I seem to remember that this has
> been asked before but
> can't seem to find that thread anymore. Probably searching with the wrong
> keywords so if
> someone can point me in the right direction, please?Unfortunately, RT's TicketSQL cannot compare two fields like that. It's hard to free up the engineering time required to make it go right now. Hopefully at some point it'll be part of a customer requirement and that will speed up implementation. -kevin
pgpVSiAC9XxI_.pgp
Description: PGP signature
