List All linked issues based on separate search (list of Epics)

Question

Hello, I have a list of Epics that have a specific status.  I would like to generate a report or filter that will show me all linked issues based on any Epic that has this status.  I've seen a way of doing this where you manually enter which Epics you want to see linked issues from, and a few different ways using various plugins, but I need something where it is dynamic, does not require a plugin, and does not need manual intervention every time an Epic Status is updated.

Something like issues where Epic Link in (Epic status = "In Progress")

Rahul_RVS · Answer

Hi @vbetoglou

You can also try out Agile Tools, to track progress of issues in your Links hierarchy on time estimates and at story points as well.

Agile Tools - Epic Tree, Links Tree and Time in Status

The add-on allows you to visualize your Links hierarchy with option to view all your custom fields on a single screen.

Key features of Links Hierarchy:

* Sum up - Roll up for Time estimates and Story Points
* Excel like editing for key fields
* Epic Tree on Issue Screen
* Custom field roll up

You also get 2 other important functionalities within the same plugin, Epic Hierarchy (standard Jira Epic -> Story -> Subtask hierarchy) and Multiple Time in Status reports (to track your issues).

Daniel Turczanski - JQL Search Extensions · Answer

Hi @vbetoglou

Standard JQL doesn't support it. As you said, you could make a static list of epics and manualy craft your query this way. This only works for very simple scenarios. In your case you should consider using an app.

You may want to join thousands of companies that use our professional indexing service:

* JQL Search Extensions

After you install the app you can simply run JQL queries like this:

issue in childrenOfEpicsInQuery("status='In progress'")

You can check more in our docs here.

Also, it's worth checking if your Jira already has some kind of JQL extensions in place already.

vbetoglou · Answer

Thank you for the reply.  You are most likely correct from what I gather.  Will look into it if we go that route.