nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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!

Accepted answers

Jayesh Raghuvanshi

@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

All comments

Nikola Perisic

Welcome @Jessica Fallon

Have you tried after AND statement to use

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

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.

Jayesh Raghuvanshi

@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 _Appfire_

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

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

cloud

jira-cloud