Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Jira Structure - find sprint actual start date

larry joseph
Contributor
March 15, 2024

I need to get the date the sprint actually started date/time not it's planned start date/time.  The Sprint item property has endDate (planned end) and completeDate (actual completion date), but for the sprint start it only has startDate which is the planned start, not the actual.  Is there a way to get the actual start date/time?  This data is show on the Sprint Report so it appears Jira is tracking it.  Is there a way to get the sprint's actual start?

image.png

 

1 answer

Suggest an answer

Log in or Sign up to answer
0 votes
YY Brother
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
March 16, 2024

Hi @larry joseph 

 

Welcome to the community.

The sprint actual start date is not feasible in the screen, but we can get it through REST API:
https://{site}/rest/agile/1.0/sprint/{sprintid}

e.g. http://localhost:8080/rest/agile/1.0/sprint/3

And the actual start date is:

"activatedDate""2024-03-16T17:19:12.532+08:00",

{"id": 3,"self": "http://localhost:8080/rest/agile/1.0/sprint/3","state": "active","name": "PP Sprint 3","startDate": "2024-02-01T17:17:00.000+08:00","endDate": "2024-02-09T17:17:00.000+08:00","activatedDate": "2024-03-16T17:19:12.532+08:00","originBoardId": 7,"goal": "","synced": false}

image.png

Hope it helps & thanks,

YY哥

larry joseph
Contributor
March 16, 2024

Hi, thank you for the reply.  I need to be able to do this from a Jira Structure formula, not the API.  My use case is to identify issues added to the sprint after it starts.

Like Lee Burak likes this
Katalin Hatvani
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!
October 2, 2024

Hello @larry joseph 

I don't know that did you find the solution or not, but I know how you can do this with structure : identify issues added to the sprint after it starts. 

 

Add this to a formula column:

CONCAT (if (scope_change,"➕"), " ", key)

The ➕ is my icon what will shown.

 

After define the Scope change variable:

1. Set the value to 'JQL query'

2. Click on the settings icon

3. Query type: JQL

4. Add this to the field:

issuefunction in addedAfterSprintStart("COPY YOUR BOARD NAME HERE")

 

 

 

 

 

 

Like Stepan Kholodov _Tempo_ likes this
larry joseph
Contributor
October 8, 2024

@Katalin Hatvani   I ended up using the formula below and adding a 1 day grace period since teams don't always start their sprints when planned.  Your solution is great if you know the sprint, as (TBOMK) you can't put variables into JQL formulas.  My structure is grouped by sprint so the with thesprint is getting the sprint name for the folder the issues are grouped under.  Then it adds a day to the sprint's start date.  Next if gets the sprint it was in as of that date.  Last if that sprint is the sprint for the group then it was there at beginning of the sprint, else it was added after.

 

if issuetype :
with thesprint = parent#level=1{summary} :
with start = DATE_ADD(sprint.filter($.name = thesprint).startdate, 1, "day") :
with asofsprints = historical_value(this, "sprint", start) :
if asofsprints.filter($.name = thesprint) = thesprint : "N" else "Y"

Like Stepan Kholodov _Tempo_ likes this
TAGS
AUG Leaders

Atlassian Community Events