How to filter/query all issues with more than one layer of linking

[li chen]

Hi,

I tried to search existing posts, but did not seem to find anything similar to my question.

I have an issue hierarchy something like this:

A linked to (consists of) B  and C

B linked to (consists of) x and y

while C linked to (consists of) m and n.

 

I would like to query what are the leaf issues in above example, i.e.: x, y, m, n by using A as the indicator (query input). 

Is it possible? 

I know for one layer, I can query out B and C by using :

issue in linkedIssues(A, "consists of")

but I don't know how to get the further layer, the x, y, m and n.

Thanks

[Rahul_RVS]

Hi @li chen 

If you are ok for a third party add-on, you can try out Agile Tools, to track progress of issues in your Links hierarchy

Agile Tools - Epic Tree, Links Tree and Time in Status 

The add-on allows you to visualize your Links hierarchy with option to view all your custom fields on a single screen.

Key features of Links Hierarchy:

• Links Hierarchy upto 10 levels deep
• Progress % on "remaining estimate" or "original estimates"
• Edit Issue summary, time estimates, story points and assignee on the tree with real time updates in the progress
• Rolled up percentage completion at all levels

You also get 4 other important functionalities within the same plugin, Epic Hierarchy (standard Jira Epic -> Story -> Subtask hierarchy), Multiple Time in Status reports (to track your issues), Worklogs report and Timesheet screen

[li chen]

Thanks for the information, a 3PP add-on is not going to work for me in my case unfortunately, we are a small portion of a big project that I don't have the admin right to use any add-on.

[Benjamin]

Hi @li chen ,

I have seen this case. A has no relation to the lower layers. The design is to search for direct links. You may want to explore the middle layer and query from there since it has connection for top and Bottom layers.

Hope this helps.

Thanks,

Ben

[li chen]

Thank you Ben, I just found this post, 

https://jira.atlassian.com/browse/JRASERVER-21936?error=login_required&error_description=Login+required&state=e8be95ba-dff2-4c91-9058-eee5c377073b 

with "nested JQL function calls", I maybe able to do it, I was just wondering is there any native supported function that might be meeting this needs.

[Benjamin]

You welcome. none that I'm aware of. There are add-ons out there to extend the JQL but you want to make sure you choose the right platform since some of them are only support on server/DC and not on cloud. 

-Ben