Question about JIRA queries

[David.Aplin]

Is it possible to write a query that provides a hierarchical response. For example, I'd like to display a table of value, where the second set of values are dependant upon the first, and the third set is dependant upon the second.

For extra clarity, I'm running a query in my first column which returns details of Objectives that have been created in a project. In the second column, I'd like to return details of Outcomes that have a relationship with those Objectives, and in my third column I'd like to return details of Epics that have a relationship with the Outcomes. The Objectives and Outcomes exist in one project and the Epics in another, and I'd like them presented in a manner that makes it clear which issues have a relationship with which other issues i.e. Objective 1 has 2 Child Outcomes and the 2 Child Outcomes have 3 and 4 Child Epics, respectively.

[Trudy Claspill]

Hello @David.Aplin 

Welcome to the community.

Jira does not have built-in functionality that will generate the results you want in a single query.

You might be able to use the API to execute multiple queries, leveraging the output of each query to construct the next query, and put it together in the presentation you want. There might also be third party apps available in the Atlassian Marketplace that would extend the search capabilities to get the data you want in a single query, but not I don't think any of those can generate the presentation you have described.

[Ravi Sagar _Sparxsys_]

Hi @David.Aplin 

Not using the issue navigator. In Jira issues can be linked to each other using issue links or using parent-child relationships (sub-tasks) but the issue navigator will just give you all the results based on a criteria.

What you are looking for seems like something that might be possible using Structure because it can visualise dependencies for you or may be using eazyBI. There are other apps as well. Advanced Roadmaps btw already has this dependency report and it show issues in different hierarchy as well for planning at different levels.

I would also say that you can also export Jira issues to csv or REST API or use other reporting tools to get this kind of a report.

I hope it helps.

Ravi