Quick Filter to show all stories and subtasks for stories in specific epics for a sprint board

[Jessica Fallon]

Hi - I would like to create a quick filter for our sprint board that shows all stories including their subtasks for stories in specific epics.  So far I have this, but I cannot find a way to include subtasks.  

project = x AND parent in (x, y, z) AND status != "Won't Do" AND type in (standardIssueTypes(), subTaskIssueTypes())

Any help is appreciate to facilitate better shared alignment between delivery and dev team.  thanks!

[Jayesh Raghuvanshi · Accepted solution]

@Jessica Fallon 

You can use below filters for your requirement

• Stories + their subtasks for specific epics:
  project = X AND parentEpic in (EPIC-1, EPIC-2, EPIC-3) AND issuetype in (Story, Sub-task) AND status != "Won't Do"

• All child work (stories, tasks, bugs) and their subtasks for specific epics:
  project = X AND parentEpic in (EPIC-1, EPIC-2, EPIC-3) AND issuetype != Epic AND status != "Won't Do"

• If you also want to show the epics themselves:
  (project = X AND parentEpic in (EPIC-1, EPIC-2, EPIC-3) AND issuetype != Epic AND status != "Won't Do") OR key in (EPIC-1, EPIC-2, EPIC-3)

Possible issue with your JQL

• parent in (...) only matches subtasks whose direct parent is in that list; stories don’t have a “parent” set to an Epic, so they are excluded
• "Epic Link" filters stories/tasks under an epic, but it does not include their subtasks because subtasks don’t have an Epic Link

Thanks
Jayesh R

[Jessica Fallon]

Thanks!  Using "parentEpic" instead of "parent" was a useful suggestion.  

[Lukas Maczejka - JXL]

Hi @Jessica Fallon,

welcome to the community!

as mentioned by others - there's ways to get all subtasks into your filter result using some JQL tweaks.

If you want a more visual experience, and if you're open to solutions from the Atlassian Marketplace, you may want to have a look at the app that my team and I are working on, JXL for Jira.

JXL is a full-fledged spreadsheet/table view for your Jira data that allows viewing, inline-editing, copy-pasting, sorting, and filtering by all your work items' fields, much like you’d do in e.g. Excel, Google Sheets, Smartsheet, or Airtable.

It also comes with a long list of further features, like custom hierarchies (including epics and subtasks). This is how it looks like in action:

This is really just one of a virtually infinite number of sheets you can build - it all depends on what data you want to see and drill into.

Any questions just let me know,

Best,
Lukas

[Gor Greyan]

Hi @Jessica Fallon

Welcome to the Atlassian Community!

project in JCM AND (parent IN (JCM-71) or issuetype IN subTaskIssueTypes()) AND statusCategory != Done

I tried this one and it worked. Check also this one.

[Nikola Perisic]

Welcome @Jessica Fallon 

Have you tried after AND statement to use 

issuetype in (standardWorkTypes(),subtaskIssueTypes()) ?