Finding scrum board where sprint was created

[Greg Bailey]

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.

[Andy Heinzer · Accepted solution]

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]

So how would you find this out in Jira Cloud?

[Andy Heinzer]

@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.

[Greg Bailey]

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!