Forums

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

How to get originBoardId in SQL (Not Rest API or GQL)

Royee Sasha Goldberg
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!
May 2, 2020

When I use REST api:

 

GET /rest/agile/1.0/board/{boardId}/sprint

 

I get response that looks like this:

 

{
  "maxResults": 2,
  "startAt": 1,
  "total": 5,
  "isLast": false,
  "values": [
    {
      "id": 37,
      "self": "https://your-domain.atlassian.net/rest/agile/1.0/sprint/23",
      "state": "closed",
      "name": "sprint 1",
      "startDate": "2015-04-11T15:22:00.000+10:00",
      "endDate": "2015-04-20T01:22:00.000+10:00",
      "completeDate": "2015-04-20T11:04:00.000+10:00",
      "originBoardId": 5,
      "goal": "sprint 1 goal"
    }
  ]
}

 

In the response I get originBoardId.

 

My question is; given a boardId and sprintId, how can I get the originBoardId from SQL

1 answer

0 votes
Nic Brough -Adaptavist-
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Champions.
May 2, 2020

You don't.

The code in Jira is working it out and presenting it on the API.  There is no data for it in the database.

Suggest an answer

Log in or Sign up to answer