Recursive Query ( Or a function) to get Parent of Issue

[Prasanna S Vanguri]

Hello - We have created two projects in our Jira instance
1. Portfolio 2. TEAMS
Our hierachy is as follows :
Initiative -->Sub-Initiative --> EPICS --> Stories

All our stories are in #2 TEAMS project - In a Story we have linked to EPIC ; 
All the remaining hierarchy is in #1 Portfolio ; In EPIC definition we have linked Sub-Initiaitve and in SI definition we linked Initiative. 

When we create a filter to pull stories from TEAMS project , I am only getting parent of a story ( which is EPIC) -I am not getting EPICS's parent ( that is sub-inititative) and Sub-initiative's Parent ( which is Initiative).

Is there any recursive query /function we can write to get EPICS, Sub-initiatives, Initiatives along the same row for a story ?

Appreciate help.

Prasanna

[Bill Sheboy]

Hi @Prasanna S Vanguri 

You cannot perform such a search with out-of-the-box Jira.  If you have any of the marketplace addons to enhance JQL, such as ScriptRunner, you could construct a recursive search by the parent linkage.

Best regards,

Bill