What is the JQL to show tickets under a feature?

[Rozalina Tsvetkova]

Hierarchy is Enterprise Epic-->Initiative-->Feature-->Epic-->Story/Task/Spike/Defect/Bug

[Fabian Lim · Accepted solution]

Hi @Rozalina Tsvetkova

Welcome to the community!

Since you are in premium, you can try this: https://support.atlassian.com/jira-software-cloud/docs/search-for-advanced-roadmaps-custom-fields-in-jql/

portfolioChildIssuesOf("issue key")

[Rozalina Tsvetkova]

Thank you. Unfortunately this query doesn't work for Features which are a custom level.

[Mikael Sandberg · Accepted solution]

Hi @Rozalina Tsvetkova

Welcome to Atlassian Community!

You need an app to get that result, out-of-the-box JQL cannot do nested queries that is needed to get the feature and issues under it. I have used JQL Tricks and Enhanced search in the past to do that, but check the Marketplace because the are other apps that can do this as well.

[Rozalina Tsvetkova]

Thank you

[Hannes Obweger - JXL for Jira · Accepted solution]

Hi @Rozalina Tsvetkova

I feel it's important to clarify if you

a. want to retrieve the issues via JQL (i.e., as a plain list of issues), or

b. want to see the issues "in their hierarchy", with child issues "below" their respective parent issues.

If it's the former, you're probably best off with one of the Marketplace apps that extend JQL by additional functions, including hierarchy-related capabilities. I've used JQL Search Extensions a few times and it works great.

If it's the latter, there are also a number of options available. Advanced Roadmaps, which is part of Jira Premium, has already been mentioned; alternatively, there are many hierarchy-focused apps available on the Marketplace. I myself happen to work on such an app, in which this would be trivial to do; I'll provide more information below.

Best,

Hannes

[Hannes Obweger - JXL for Jira]

Just to expand on the last point, this is how this would look in the app that my team and I are working on, JXL for Jira:

For context, JXL is a full-fledged spreadsheet/table view for your issues that allows viewing, inline-editing, sorting, and filtering by all your issue fields, much like you’d do in e.g. Excel or Google Sheets. It also comes with a range of advanced features, including the support for configurable issue hierarchies. These issue hierarchies can be configured based on Jira's built-in parent/child relationships, and/or based on issue links.

Any questions just let me know!

[Rozalina Tsvetkova]

 Thank you

[mauricio.groth · Accepted solution]

Hi @Rozalina Tsvetkova 

I’m Maurício, a support engineer at Appfire and I’m here to help you.

Unfortunately, using JQL of Jira, you’ll not be able to do it dynamically.

In the app where my team works, JQL Search Extensions for Jira, you can use this query to display all issues under a feature:

issue in childrenOfIssuesInQueryRecursive("issuekey=ABC-1”)

Please note that we have created a support ticket https://jqlsearchextensions.atlassian.net/servicedesk/customer/portal/2/SEARCH-1110  in our portal, and we request you to sign in to the portal and let us know the username so that we can mark you as the reporter so that you will be able to access the ticket. 

Please find the below link to signup to the portal: https://jqlsearchextensions.atlassian.net/servicedesk/customer/portal/2 

Looking forward to hearing from you!

Thanks,
Mauricio

[Rozalina Tsvetkova]

Thank you

[Danut M _StonikByte_ · Accepted solution]

Hi @Rozalina Tsvetkova,

Grouping is not possible in JQL. 

But you could try the Work Breakdown Structure (WBS) dashboard gadget offered by our Great Gadgets app.  It does the grouping for you and displays the issues from a filter in form of Epic > Stories, Tasks, Defect > Subtasks along with their status.

If you have additional levels (Initiatives) on top of epics defined in Advanced Roadmaps, it will display the hierarchy Initiative Level 1 > Initiative Level 2 > ... Initiative Level n > Epic > Stories, Tasks, Defect > Subtasks   

All you have to do is to create a filter that returns all the issues to be grouped, and to configure the gadget to use this filter. 

This app offers many other gadgets that you might find useful. 

If you have questions, please do not hesitate to contact us at support@stonikbyte.com.

Thank you,

Danut M. 

[Rozalina Tsvetkova]

Thank you.