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

Atanu March 14, 2024

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?

3 answers

1 accepted

0 votes
Answer accepted
Hannes Obweger - JXL for Jira
Marketplace Partner
Marketplace Partners provide apps and integrations available on the Atlassian Marketplace that extend the power of Atlassian products.
March 14, 2024

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
Marketplace Partner
Marketplace Partners provide apps and integrations available on the Atlassian Marketplace that extend the power of Atlassian products.
March 14, 2024

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:

5-level-hierarchy.gif

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!

1 vote
Trudy Claspill
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
March 14, 2024

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?

0 votes
Harsh
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
March 14, 2024

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 March 20, 2024

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

Suggest an answer

Log in or Sign up to answer