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
4,300,977
Community Members
 
Community Events
165
Community Groups

JQL query to get all linked tickets

Edited

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

 

João

 

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 L3...no direct linkage between L1 and L3

Hope this helps!

 

Thanks 

Untitled.jpg

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
fields

 

Links HIerarchy.PNG

Like Joao Oliveira likes this

would still prefer a jql query

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
FREE
TAGS

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