JQL query to get all linked tickets

[Joao Oliveira]

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

[Sreenivasaraju P]

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.

[Joao Oliveira]

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 

[Rahul_RVS]

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

[Joao Oliveira]

would still prefer a jql query