Forums

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

Finding scrum board where sprint was created

Greg Bailey
Contributor
September 3, 2019

Hi,

  I've seen the answer to this question before but i can't seem to find it now. 

I need to find out what scrum board a sprint was created in.  I understand it requires executing queries against the DB but can't find the right query to run.

Is anyone able to help me with this?  Thanks in advance.

 

2 answers

1 accepted

2 votes
Answer accepted
Andy Heinzer
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
September 4, 2019

Hi Greg,

This is something you can do in Jira Server if you have access to the database.  But this is not as easily determined in Jira Cloud since those users don't have SQL access.   In my Postgresql instance I used a query like this to find all the sprints and list the board where they were initially created:

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 won't show sprints that are created by the sample data process, technically they aren't created on a sample board, but auto generated.  This query will show any sprints created by a user, and the board listed is the board where that sprint was created.  Just for the sake of others that might find this, please be aware that sprints can exist across multiple boards simultaneously.

I hope this helps.

Andy

Richard Cross
Contributor
January 31, 2023

So how would you find this out in Jira Cloud?

Andy Heinzer
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
January 31, 2023

@Richard Cross This method above was specifically noted for server.  End users do not have the ability to use that method in Jira Cloud since users do not have direct access to the database.

That said, you could use a REST API call to endpoint GET /rest/agile/1.0/sprint/{sprintId}

In the response of that endpoint is a value called originBoardId.  This provides to you the board that sprint was created upon.  You could then also call GET /rest/agile/1.0/board/{boardId}  and pass it the id from the first query to learn more about that board if your account has permissions.

Like # people like this
0 votes
Greg Bailey
Contributor
September 4, 2019

Thanks so much Andy!  Im on Jira Server and have access to the database so I will be able to do this.  My challenge will be converting the query to one that will work on MySQL as that is the DB we have in place.  This query looks basic enough I should be able do that with no problems.

 

Thanks again!

Suggest an answer

Log in or Sign up to answer