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"
In Above screenshot, there are 2 issues has been linked to Epic. Need help to get same data in SQL query
Finally i found it. Below the query which gives list of issues which is linked to Epic
li.summary as ISSUES_IN_EPIC, I.ID AS ISSUELINKID
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'
"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
Hello @Santosh V
I don't think it's required to write SQL queries yourself to extract the data from Jira and display via power BI
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 ?
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