Finding issues from initiative to all the way till task using JQL query.

[Prashant Agrawal]

Dear Experts,

I am looking for a JQL query which can list all the issues that are connected to an Initiative. 

Below is the structure.

----> Initiatives

------------>Epics

------------------->Stories and Task 

Epics to Initiative are connected using the JIRA link as "Implements". Stories /Task are connected to Epics using Epic link (direct children).

I am building a JQL which can list all the initiative and its children based on component filter at Initiative level. I am able to get the list of features & epic but not able to get the story and task under Epics. 

This is what the query i have used. 

issueFunction in linkedIssuesOf('project in("A", "B") and component = "XYZ"') - This is giving the list of epics.

Now to get the list of issues in the Epic i have tried using above query in

issue in issueinEpicwhere(gave the above query)

but not of any help.  

Wondering if anyone could suggest how can i get the complete list of issues.

[Ilze Leite-Apine - eazyBI]

Hi @Prashant Agrawal 

As @Fabian Lim mentioned, you can do this also with Jira apps. 

eazyBI is a Jira app for reporting and charts, and you can analyze issue hierarchies that are based on issue links here. For that, you need to define how issues are linked and how to build the custom hierarchy, and then import this new custom hierarchy for further analysis.

There is an example report you can check out: Issue custom hierarchy - Improvements 

In this example, there is an Issue hierarchy with two levels upon epics - Improvement and Feature. Quantitative values (Original estimated hours, Hours spent, Issues created, etc) for higher-level issues show totals from their children, while the issue attributes or properties (like Issue type) are displayed for each issue. You can expand or collapse rows to show the level you need.

Do not hesitate to contact support@eazybi.com for any further questions or assistance!

Best, 

Ilze, eazyBI Customer Support consultant

[Fabian Lim]

Hi @Prashant Agrawal

I would recommend you look at various plugins that could do this for you because using jqls will become a nightmare.  Below are plugins that we use with our clients:

1. Structure for alm works

2. EazyBi

3. Bigpicture

Cheers.