Please can you help me with a JQL query that shows all linked tickets

[Atanu]

Please can you help me with a JQL query that shows all of the items underneath 3 business outcomes including the linked initiatives, features underneath these and the stories/tasks underneath the feature?

[Hannes Obweger - JXL for Jira · Accepted solution]

Hi @Atanu

welcome to the community!

When you say linked issues, are you referring to issues that are connected to each other via issue links? Or are you referring to different levels of a configured issue hierarchy?

If it's the latter, Advanced Roadmaps is likely the right tool for you. Among many other things, it comes with a tree structure of your issues, listing parent issues "on top" of their respective children.

If you are referring to issue-linked issues, I believe you'll need extra tooling for what I understand you want to achieve. There are a number of hierarchy-focused apps available on the Atlassian Marketplace, with different levels of support for issue links. I'll provide an example below.

Best,

Hannes

[Hannes Obweger - JXL for Jira]

Just to expand on my last point, this is how it could 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 number of advanced features, including support for (configurable) issue hierarchies. These issue hierarchies can be based on Jira's built-in parent/child relationships (like task/sub-task), and/or based on issue links of configurable issue link types (like is parent of / is child of).

Any questions just let me know!

[Trudy Claspill]

Hello @Atanu 

Welcome to the Atlassian community.

Are you using the Advanced Roadmaps feature to create hierarchy of these issues?

If so have you looked at the childIssuesOf() JQL function?

[Harsh]

Hi @Atanu 

Could you confirm if you need all linked issues for a specific project?
I do not get underneath 3 business outcomes? can you explain in detail or rephrase it again?

[Atanu]

Hi @Harsh 

Actually in our project there are only 3 business outcomes and initiatives are linked to it and under initiative features are linked and under that stories and tasks are there.

Finding an Jql which gives all the issues in short.

Thanks