[rt-users] Searching and comparing two date field values instead of value with supplied valid

[Kevin Falcone]

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
-------------- 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/20130812/5b010ed5/attachment.sig>