[rt-users] Searching for repeating tickets

Jeffrey Pilant jeffrey.pilant at bayer.com
Wed Sep 30 17:04:30 EDT 2015


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
________________________________________________________________________


More information about the rt-users mailing list