It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

SQL query to fetch hierarchy level details

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.

1 answer

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

Thanks,
Amith Mathur

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

Suggest an answer

Log in or Sign up to answer
Community showcase
Published in Jira

The add-in you’ve been waiting for: Jira Cloud for Excel 🙌

Introducing Jira Cloud for Excel Here at the product integrations team at Atlassian, we are thrilled to announce the new Jira Cloud for Excel add-in! This add-in lets you export Jira data directly ...

973 views 10 25
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you