Nested JQL Statements for Filters?

[Brian Moudy]

I'm looking for a way to automate a manual three-step process into a single filter. We have a label which tracks if the tickets are special. I want to see all other tickets associated with the strike teams (custom field) who have a special label ticket.

Step 1 - Filter for all tickets with a specific label.

JQL = (PROJECT = Foo and LABEL = Special)

Step 2 - Extract the value of a custom field for all tickets returned in Step 1

Results contain Strike Team values of "Excelsior" and "Faraday"

Step 2 - Filter for all tickets with custom field that matches the extracted value

JQL = (PROJECT = Foo AND Strike Team in ("Excelsior", "Faraday"))

I was hoping I could do a ScriptRunner field compare, but I cannot figure out how to make it work properly. Any ideas?

Thank you!

[Aidan Derossett _Adaptavist_]

Hey Brian!

I'm definitely a little late to this one, but if you're still actively looking for an answer I'd like to help you out!

Get back to me and let me know! :)

Thanks

Aidan