How to show sub-tasks based on field in parent tasks in dashboard

[meredith_poole]

Hi! I'm trying to get a count/list of sub-tasks in a dashboard, based on a field in the parent task. For example, all Tasks have a field called "Team" which is filled in like {Team 1, Team 2, Team 3, etc}. All of these Tasks have Sub-tasks, but the Sub-tasks don't have the "Team" field. I want to be able create a dynamic filter to select Team 1 in a dashboard based on the Tasks, and return all of the Sub-tasks associated with these tasks. Basically just be able to get a visual that shows something like "Team 1 has 6 sub-tasks"

I have access to Rich Filters and Scriptrunner, but can't add any more apps. 

[Gustavo Moraes]

Good day, @meredith_poole

If you create an automation to fill the "Team" field on each Sub-Task based on the parent, wouldn't it work for you?

You could start setting it as a scheduled automation, to update existing sub-tasks, and then configure it so that whenever the sub-task is created or edited, this field is already populated based on the parent.

Or by any chance you can't have the Team field on the Sub-Task?

[Mathew Lederman]

In ScriptRunner's Enhanced Search you would just do:

 issueFunction in subtasksOf("Team = 'Team 1'") 

Unfortunately in Jira Cloud you can't use ScriptRunner's searches in normal JQL or for dashboards to the best of my knowledge.