Mailing List Archive: Request Tracker: Users

Searching and comparing two date field values instead of value with supplied valid

Index | Next | Previous | View Threaded

landonstewart at gmail

Aug 10, 2013, 4:34 PM

Post #1 of 3 (19 views)
Permalink

Searching and comparing two date field values instead of value with supplied valid

Hello,

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''

With normal MySQL queries one can compare two table columns so I'm
wondering if there's a way to do this with the SQL syntax that RT uses.

--
Landon Stewart <LandonStewart [at] Gmail>

jvdwege at xs4all

Aug 11, 2013, 12:23 AM

Post #2 of 3 (12 views)
Permalink

Re: Searching and comparing two date field values instead of value with supplied valid [In reply to]

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?

Regards,

Joop

falcone at bestpractical

Aug 12, 2013, 7:38 AM

Post #3 of 3 (2 views)
Permalink

Re: Searching and comparing two date field values instead of value with supplied valid [In reply to]

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

Index | Next | Previous | View Threaded

Interested in having your list archived? Contact Gossamer Threads