How do I get a view which shows me ONLY the Parent stories with the OPEN subtasks

Question

Hi,

I'm working on a structure to follow up subtasks tasks.
The relation between Story and Subtask is as follows:

Example:
Story A (assigned to Product owner) -> Status: In progress
           |__> Subtask A.1(Assigned to iOS dev) - Status: In progress
           |__> Subtask A.2.(Assigned to Android dev) - Status: In Progress

Story B (assigned to Product owner) -> Status: In progress
           |__> Subtask B.1(Assigned to iOS dev) - Status: Resolved
           |__> Subtask B.2.(Assigned to Android dev) - Status: In Progress

Now I want to be able to get a view which shows me ONLY the Parent stories with the OPEN subtasks of the iOS dev.
So excluding the Parent story when the iOS subtask is Resolved or Closed.

So resulting in:
Story A (assigned to Product owner) -> Status: In progress
           |__> Subtask A.1(Assigned to iOS dev) - Status: In progress

Could someone help me in my search for a solution?

Thanks in advance!

Kind regards,
Alex

Alexander Agneessens · Answer

Hi Yulia,
My apologies for my late reply but I was able to solve it.
Thanks for your input!

So if you want to have all stories & the sub-tasks of these stories in one JQL filter, you have to refer in your JQL filter to a structure.

So first create your structure e.g. "STRUCTURE_X"
In your structure you use as JQL query to insert all stories linked to that epic:
issue in linkedIssues("epic-1234") or ("Epic Link" = epic-1234)

Now you have a structure with all the stories linked to the epic.
What is still missing are the "subtasks"
So in your structure, you add -> Extend > Subtasks...

Now you have a structure with all stories and all subtasks connected to these stories.
So the structure results in Epic > Story > Subtasks

Now you go back to your quick filter:
and add the following JQL query: issue in structure("STRUCTURE_X")

Yulia Barbash _ALM Works_ · Answer

Hello @Alexander Agneessens

Yulia from ALM Works here!

If you are looking to accomplish this view by creating a new structure, here is an option that should work

* Add insert generator: project =projectName AND assignee = productOwner AND issuetype = story
* Add sub-task
* You can add filter generator or use quick filter to all levels : issuetype = Sub-task AND status != Closed AND team = teamName.

Let me know if that helped to achieve your goal.

Best regards
Yulia Barbash
www.almworks.com