Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

How can we get the list of boards associated with a Sprint through SQL query from JIRA DB

Jayasree SenthilKumar
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
July 24, 2020

How can we get the list of boards associated with a Sprint through SQL query from JIRA DB.

SELECT sprint."NAME" as "Sprint Name", board."NAME" as "Board Name" 
FROM "AO_60DB71_RAPIDVIEW" board
JOIN "AO_60DB71_SPRINT" sprint ON board."ID" = sprint."RAPID_VIEW_ID"

This query gives the Sprint and the board in which the sprint is created. But I would like to have the Sprints and all the boards, the sprint appears.

 

 

0 answers

Suggest an answer

Log in or Sign up to answer