nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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.

Accepted answers

Andy Heinzer

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

All comments

Andy Heinzer

Hi Greg,

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";

I hope this helps.

Andy

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!

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.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

server

jira

jira-software

jira-software-server