Filter to show all "open" "in progress" "closed" subtasks and stories that are linked to an epic

Question

Hello,

I have an Epic with Stories and Sub tasks.

I would like to create a filter or view in a dashboard all the open stories and issues linked to that epic based on their status.

E.g. to view all in progress Sub tasks in a Story that linked to the Epic.

Thank you in advance!

Earl McCutcheon · Answer

Hello @Namir Brentegani ,

In addition to the post mentioned by @Sri Kumar , I just wanted to expand on this a bit to give some additional context and alternate options. The thread mentions using the Add-on  JQL Booster Pack abd below are some additional options:

To get an Epic and the Child issue of the epic, you could use the following JQL:

"Epic Link" = EXE-123 OR parent in ("EXE-123")

However this will not be reciprocal to also include subtasks of the issues in the Epic, because Natively Jira cannot nest queries for a comparative result set between two issues or JQL sets, we have a feature request for this at the link below, and make sure to add your vote to help track interest:

* https://jira.atlassian.com/browse/JRASERVER-21936

Because of this to be able to get the child issue of an epic and the subtasks of those child issues for a full hierarchy map you need to look into an add-on that extends the native functionality to allow nested queries to build out that relationship between the issues.

In addition to the add-on mentioned in the alternate thread  I know, ScriptRunner also has extended functionality via an Scripted JQL function "SubTaskOf() and ParentOf()"  that can be used to get a nested comparison of subtasks and parent issues where you add in an additional nested Subquery to determine the issues meets certain criteria of the hierarchy.

Also, the PowerScripts app has a similar script to ScriptRunner, and I would recommend checking out their documentation site here.

Another free option would be to create an external report using native functionality in Google Sheets or Excel using either Jira Cloud for Google Sheets (Official)  or Jira Cloud for Excel (official) to export the live issue date to the external spreadsheets than comparing the results with lookup operations based on the various field outputs.

Hope this helps to get you on the right track.

Regards,
Earl

Sri Kumar_10fwob · Answer

Hi @Namir Brentegani ,

Good day. Welcome to Atlassian Community.

Can you check this thread and see if this helps:
https://community.atlassian.com/t5/Jira-Software-questions/JQL-to-show-all-issues-and-subtasks-in-an-epic/qaq-p/1432325

-Sri