Query Help to Display Sub-Tasks for Stories Within An Epic

Question

I'm trying to display stories and all of their sub-tasks on a Kanban board for a specific Epic. I've messed with the queries a bunch of different ways but I either get all of the stories and sub-tasks for the whole project or I don't get anything.

Here's my query that I'm tinkering with, I know the "Or" in the query is why everything is coming back for the project but I've done variations of "AND" and none of them seem to work.

project = GCSOBSR AND issuetype in (subTaskIssueTypes()) OR "Epic Link" = GCSOBSR-2 ORDER BY Rank ASC

Tong Lu · Answer

Thank you, I'll look into this.

Rahul_RVS · Answer

Hi @Tong Lu

If you would be interested in a marketplace app, you can try out our add-on

Agile Tools - Epic Tree, Links Tree and Time in Status

It helps you to visualize the issue hierarchy and sum up of numeric fields at each hierarchy level, up to 10 levels.

Key features :

* Hierarchy upto 10 levels deep
* Progress % on "remaining estimate" or "original estimates"
* Edit Issue summary, time estimates, story points and assignee on the tree with real time updates in the progress
* Rolled up percentage completion at all levels
* Ability to add/remove the columns on the report

Along with this there are multiple other features like Time in Status, Worklogs reports etc which the app provides.

Hannes Obweger - JXL for Jira · Answer

Hi @Tong Lu ,

just adding to Trudy's answer - if you're open to apps from the Atlassian Marketplace, there's a number of apps that allow displaying issue hierarchies. In most cases, you don't have to explicitly play around with JQL; the app would "resolve" the parent/child relationships for you. It's also worth nothing that these views are different from the Kanban board - but of course you can view the same set of issues.

E.g. this is how this looks in JXL for Jira, the app that my team is working on: