Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
Community Members
Community Events
Community Groups

JQL query to get all linked tickets


Hi There

I have a Level 1 ticket which is linked to 2 other tickets by "Realized by" (Level 2).

Each Level 2 tickets, have other Level3 and Level 4 tickets, all linked using the "Realized by".

Using "issue in linkedIssues("Level1Ticket", "Realized by")", only brings L1 and L2 tickets but not the full hierarchy.


Anyone faced a similarproblem or have a solution to share?

Thanks in advanced for any help




1 answer

Hi @Joao Oliveira ,

Welcome to the community.

Need small clarification on your requirement scenario:

ticket A linked to B , B linked to C, C linked to D. But there is not direct link between A & C and A&D. you want JQL query to list all these tickets? Please clarify.

Hi Sreenivasaraju,

Thanks for the welcome :)


Here's an overview of my scenario- with the issue in linkedIssues("Level1Ticket", "Realized by") , I'm only able to get L1 and L2 tickets. I would like to get the entire hierarchy until L4 (or even beyond if any L5 tickets would be created one day). 

L1 ticket connect to L2, L2 to direct linkage between L1 and L3

Hope this helps!




Rahul_RVS_Support Marketplace Partner May 26, 2022

Hi @Joao Oliveira 

If you would be interested in a mktplace app to visualize your issue hierarchy based on links you can try out our add-on,

Issue Hierarchy Reports 

And generate insights such as:

- View the full Jira Issue Type hierarchy of Linked issues,
Portfolio/Advanced Roadmaps, Epics, and Subtasks up to 10 levels.

- % complete based on time spent and story points at each hierarchy level

- Sum up Time Spent, Org Estimate, Time Rmng, custom number


Links HIerarchy.PNG

Like Joao Oliveira likes this

would still prefer a jql query

Suggest an answer

Log in or Sign up to answer

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you