Filter Help - 2 data pass filter. is this possible?

[Brittan Call]

I am looking for a what I believe would be a 2 pass filter.

In plain filter speak:   
I need to return ALL ISSUES related to linked work and the LINKED ISSUES CHILDREN in a specific EPIC and I have a growing ist of these epics.

Example:  I have an overall effort EPIC  (EPIC-01, EPIC-02, EPIC-03...etc.)  I will need to have all linkedissue (EPIC-01, EPIC-02...etc)

AND (Children of the above Filter return)

I don't even know if this is possible.  Any assistance would be greatly appreciated.

[Charlotte Santos -Appfire-]

Hi @Brittan Call 

I’m Charlotte, a support engineer at Appfire and I’m here to help you.

Unfortunately, natively, you’ll not be able to do it dynamically.

In the app where my team works, JQL Search Extensions for Jira, you can use the following query to get the linked issues of the epics and you will also be able to save it as a filter:

issue in linkedIssuesOfQuery("key in (EPIC-01, EPIC-02, EPIC-03)")

Save as filter (e.g. ‘Linked Epic’).

Then use the following query to get the children from said filter:

issue in childrenOfIssuesInQuery("filter = 'Linked Epic'")

Please contact our support if you have any other questions about this query, or the app in general.

We’ll be happy to help you! 😉

[Bill Sheboy]

Hi @Brittan Call -- Welcome to the Atlassian Community!

That is not possible with the built-in features of JQL.

Do you have any marketplace addons to JQL, such as ScriptRunner?  I believe that supports queries like that.

Kind regards,
Bill

[Brittan Call]

What about calling a saved filter in a filter?

[Bill Sheboy]

No, that will not help.

You are describing a nested query, or JOIN between the result sets, and out-of-the-box JQL is not a SQL: it does not have those types of features.