Searching for repeating tickets

Hi

We’re using the Repeat Ticket extension
(http://blog.bestpractical.com/2013/03/scheduled-ticket-creation-in-rt.html).

I want to search for all “base” repeating tickets, and the only criteria I
can come up with to identify them is to search for tickets where the custom
field “Original Ticket” is equal the current ticket.

Is there a way of using such criteria in RT?

Or is there a better way of searching for repeat base tickets?

Thanks,
Keith
"Laughter is the best medicine, though it tends not to work in the case
of impotence" - Jo Brand

Keith Edmunds wrote:

We’re using the Repeat Ticket extension
(http://blog.bestpractical.com/2013/03/scheduled-ticket-creation-in-rt.html).

I want to search for all “base” repeating tickets, and the only criteria I
can come up with to identify them is to search for tickets where the custom
field “Original Ticket” is equal the current ticket.

Is there a way of using such criteria in RT?

Or is there a better way of searching for repeat base tickets?

Can you search the custom field and look for it to be equal to Tickets.id? That is, use the text “Tickets.id” instead of some number? Then when the SQL is formed, it creates something like:
Select main.* from Tickets main “CF.{Original Ticket}” = Tickets.id
Were you to set it to #456, it would look like:
Select main.* from Tickets main “CF.{Original Ticket}” = 456

By using the text of a field name for the original ticket id, I think it would match.

[Note: I don’t really use it, but am IT support for it here. Above is based on my guess as to how the search builder page works.]

/jeff
The information contained in this e-mail is for the exclusive use of the
intended recipient(s) and may be confidential, proprietary, and/or
legally privileged. Inadvertent disclosure of this message does not
constitute a waiver of any privilege. If you receive this message in
error, please do not directly or indirectly use, print, copy, forward,
or disclose any part of this message. Please also delete this e-mail
and all copies and notify the sender. Thank you.

For alternate languages please go to http://bayerdisclaimer.bayerweb.com

Jeffrey Pilant wrote:

Can you search the custom field and look for it to be equal to
Tickets.id? That is, use the text “Tickets.id” instead of some number?
Then when the SQL is formed, it creates something like: Select main.*
from Tickets main “CF.{Original Ticket}” = Tickets.id Were you to set it
to #456, it would look like: Select main.* from Tickets main
"CF.{Original Ticket}" = 456

By using the text of a field name for the original ticket id, I think it
would match.

Thanks Jeff. When I saw your reply, I had hoped it would work, but
unfortunately RT quotes “Tickets.id” so the SQL WHERE clause generated is:

‘CF.{Original Ticket}’ = ‘Tickets.id

I tried manually editing that to remove the quotes, but then it fails with:

"Wrong query, expecting a VALUE in '‘CF.{Original Ticket}’ =

Tickets.id<–here’"

There must be a way of doing this…

Keith
"Soccer is one of those things that the rest of world cares about more
than Americans do - you know, like healthcare, education and gun
control" - David Letterman