SQL query to fetch hierarchy level details

[buchi babu]

We have requirement to fetch data from Jira databade

Project-->Epic-->Feture-->Issues
This is requirement from one of our clients. So we need to write queries to fetch data from backend Database.

[Amith Mathur {Appfire}]

Hi @buchi babu , 

Welcome to the Atlassian Community!

You would be able to write any queries based on the column names and the table names. The issues exist in the jiraissue table. 

Please review the below link to find or view a Jira issue from the database using SQL

• https://confluence.atlassian.com/jirakb/to-find-or-view-a-jira-issue-from-the-database-using-sql-744524576.html

Thanks,
Amith Mathur

[buchi babu]

HI Amith,

Thanks for your quick response I am actually looking for a solution to get hierarchy level details in same query for hierarchy as follows  Projects, EPICs and Features.

Requirement is to show them in different columns in same table.

Thanks