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

Question

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- · Answer

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 · Answer

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.

Brittan Call · Answer

What about calling a saved filter in a filter?