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

[Tong Lu]

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 

[Hannes Obweger - JXL for Jira]

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:

[Trudy Claspill]

Hello @Tong Lu 

Welcome to the community.

The type of report you are trying to do is not generally possible with native Jira functionality.

What version of Jira are you using? Is it an option to pay for a third party app that would extend the searching functionality?

[Rahul_RVS]

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.

[Tong Lu]

Thank you, I'll look into this.