JQL query to get all linked tickets

Question

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

Joao Oliveira_lvh514 · Answer

would still prefer a jql query

Rahul_RVS · Answer

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_lvh514 · Answer

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