Jira Structure - find sprint actual start date

[larry joseph]

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?

[YY Brother]

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}

Hope it helps & thanks,

YY哥

[larry joseph]

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.

[Katalin Hatvani]

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

[larry joseph]

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