How to create a filter that shows subtasks from that were recently updated by epic

[Jennifer Dumble]

I have a dashboard that I would like end users to see subtasks from an epic that were recently updated. The problem is the epic is on the issue and not the subtasks. How do I get this info into a filter?

I am using this query to just see the issues but obviously it is not pulling in the activity on the subtasks. The main issue of each is not changing just the subtasks.

"Epic Link" in (SATEAM-126, SATEAM-165) AND status not in (Done, Cancelled) ORDER BY updatedDate

Thanks!

[Trudy Claspill · Accepted solution]

Jira doesn't natively have functionality to give you the report that your desire.

Do you have any JQL extension tools already installed on your instance, and if not is it an option for you company to purchase such apps?

If not, one option is to use the REST API to construct multiple queries and parse the results.

Another option would be to copy the parent story's Epic Link data to the sub-tasks in a custom field.

[Jennifer Dumble]

Thanks I am not sure how this will update the activity date on the dashboard to show the end user that there is something new though. The dashboard is built from the widgets (filter results).

[Trudy Claspill]

If you add automation to copy the Epic Link from a parent story to its sub-tasks, then you could filter for sub-tasks that were recently changed and include in the output the Epic Issue Key that you have copied to the sub-tasks.

Otherwise, you will need to look at adding a third party app that extends the JQL functionality. I used to use Adaptavist ScriptRunner at my last company with Jira Server, and that added functionality that supported using sub-filters. In that case, you could construct the filter to get the sub-tasks with the recent activity. Then use that (in combination with other JQL extensions from that same app) to filter for all the parent stories of those sub-tasks. And then use that filter to filter for the parent Epics of those stories. And then, finally, you could use that filter as the basis for your widget.