nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

JIRA SQL query to get the issue hierarchy level detai;s

narendra k

I would like to get below details in JIRA db with SQL queries

Issues under Epic

Issues under Initiative

Stories under Epics

sub-tasks under Issues.

I looked into previous discussions on these, but there is some confusion like some people used issuetype, some used issuelinktype and some used customfield. Can anyone please point me to the right direction to get above details

Accepted answers

All comments

Tarun Sapra

Hello @narendra k

Jira DB schema is pretty complicated one, and what you want is available via JQL query which can then be displayed on the Dashboard gadget or exported via CSV, thus is there any specific reason you want to do it via DB calls.

narendra k

Thanks for the reply @Tarun Sapra!

We want to generate some Dashboards on JIRA db. I am not sure how to use JQL here. However, my requirement is to use JIRA DB to generate reports.

Tarun Sapra

Jira Dashboards are made of Gadgets and Gadgets display issues fetched by JQL filters. Thus, you can use JQl filter along with some plugins to create insightful dashboards

https://confluence.atlassian.com/jirasoftwareserver077/configuring-dashboards-945534745.html

https://moduscreate.com/blog/jira-how-to-create-a-dashboard/

https://www.smartsheet.com/dashboards-view-creating-best-jira-dashboard-you-and-your-team

narendra k

That's Nice!

But unfortunately, I have to use JIRA db. Is it difficult to create dashboards on JIRA db??

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

sql

jira

jira-cloud