Display search results in the same order given by us?

[Sridhar Gandla]

Looking for help to get JQL query; Jira hierarchy as follows:   Initiative -> EPIC -> Story. 

For ex: Initiative 1 has three EPICs as listed below. (EPIC6, EPIC8, EPIC7)...

Required report in this order.....

Initiative 3

EPIC 1

EPIC 2

EPIC 3

Initiative 2

EPIC 13

EPIC  10

EPIC 9

EPIC 40

Initiative 1

EPIC 6

EPIC 8

EPIC 7

I need to get a report of Initiative with Epics are displayed strictly in the order. I am getting a report of all initiatives followed by all EPICS.  

Order of EPIC1, EPIC2 and EPIC3 is not a big deal and Initiatives order either ASC or DESC is perfectly okay but strictly Initiative, EPIC order to be maintained..

For ex:   If my query is Key in (ABC-5, ABC-3, ABC-7, ABC-9) and type =EPIC

 Is there any way to get a report strictly maintains in order given in parenthesis? 

[Sridhar Gandla]

using linkedIssuesOfRecursive gives great results for one Initative but I have ton of them... 

Purpose :   Hierarchy order strictly to be maintained in search results irrespective of Order of items in ASC or DESC. 

I tried to using subquery.  Results as follows: It is displaying all initiatives followed by EPICs.  Also, order of EPICs mix of Initiative 2 and Initiative 1.   

Initiative 2

Initiative 1

EPIC 13

EPIC  10

EPIC 6

EPIC 8

EPIC 7

EPIC 9

EPIC 40

[Trudy Claspill]

@Sridhar Gandla 

Following up on @Fabian Lim 's response, I found the following post mentions a few third party apps that might help. Not for free though.

https://community.atlassian.com/t5/Jira-questions/Show-Issues-by-Hierarchy-Epic-Story-Task-Query-JQL/qaq-p/1615745

[Sridhar Gandla]

Thank you for quick response.  Unfortunately, no 3rd party plug-ins can be installed instantly !!

[Trudy Claspill]

Do you have any third party apps already installed?

A hierarchy that allows for creating an Initiative issue type and having Jira recognize that Epics are children of that is not out of the box functionality. If you didn't use a third party app to create that hierarchy, then how have you established the parent child relationship?

[Sridhar Gandla]

Sir, to establish relation there is no 3rd party tools are required.  For ex:  Story -> EPIC is using EPIC Link and EPIC to Initiative using Parent link.. So that is Hierarchy is already maintained. 

For exporting from Jira to excel to maintain   Hierarchy there is 3rd party apps required as per above responses. I don't have any 3rd party apps

[Fabian Lim]

Hi @Sridhar Gandla

With the free plan this may not be possible.  You can use a plugin such as structure that displays the hierarchies as you out liner above.

Feel free to browse through the marketplace.

[Sridhar Gandla]

I am sorry, I don't have any plug-in and also no easy way to buy plug-ins as it is corporate /enterprise... All I have a adaptive test - linkedIssuesOfRecursive..