Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,298,803
Community Members
 
Community Events
165
Community Groups

DB query to get Issues in EPIC

Edited

I need help on DB Query to get list of issues which is linked to EPIC in JIRA application.

Below is the list of issues which is linked in EPIC.

Epic Name is "My Epic"

Capture.PNGIn Above screenshot, there are 2 issues has been linked to Epic. Need help to get same data in SQL query 

 

Regards

Santosh

 

 

2 answers

1 accepted

0 votes
Answer accepted

Finally i found it. Below the query which gives list of issues which is linked to Epic

 

SELECT
li.summary as ISSUES_IN_EPIC, I.ID AS ISSUELINKID
FROM
JIRAISSUE I
INNER JOIN ISSUELINK IL
ON IL.SOURCE = I.ID
INNER JOIN ISSUELINKTYPE ILT
ON ILT.ID = IL.LINKTYPE
INNER JOIN JIRAISSUE LI
ON LI.ID = IL.DESTINATION
INNER JOIN PROJECT PJ
ON PJ.ID = I.PROJECT
INNER JOIN ISSUETYPE IT
ON IT.ID = I.ISSUETYPE
where IT.PNAME = 'Epic'

0 votes
Tarun Sapra Community Leader Mar 18, 2019

Hello @Santosh V 

Why do you want to do a DB query?

You can do the query in Jira native JQL and export the results in the CSV/Excel

Tarun Sapra Community Leader Mar 18, 2019
"Epic Link" = <key of epic>

Above is based on out of the box features

And also possible using JQL functions from paid plugins like SR

https://scriptrunner.adaptavist.com/latest/jira/jql-functions.html#_issuesinepics

I need DB query (PostgreSQL) because am building dashboard report in power BI.

so it would be great to provide db query 

 

Regards

Santosh

Tarun Sapra Community Leader Mar 19, 2019

Hello @Santosh V 

As per this blog - https://powerbi.microsoft.com/en-us/blog/explore-your-jira-data-with-power-bi/

I don't think it's required to write SQL queries yourself to extract the data from Jira and display via power BI

Om Singh I'm New Here May 05, 2022

@Tarun Sapra 

I am building a dashboard in looker.
I have got all the relevant tables/views into the looker, joined on the appropriate id.

 Looks like directly pulling attributes doesn’t solve the problem .

Doest it require to write SQL query for each details and create a seperate derived table ?

@Santosh V how did you solve your problem ?

Suggest an answer

Log in or Sign up to answer
TAGS

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