Show sprint start/ end date in Jira Structure colum?

[Charlie Misonne]

I have a Jira Structure which groups some issues by sprint.

I'm wondering if I can show the sprint start and end date in columns using a formula? So far I'm only able to show the sprint name.

[David Niro · Accepted solution]

Hello Charlie,

David from ALM Works here.  While Structure itself cannot access the Sprint Attributes from Jira, this can be accomplished by creating a scripted field with Scriptrunner.  Through Scriptrunner, the sprint start and end date values can be displayed as columns in your structure.

You may need to modify the script, but below is a snippet of what it should look like.

import com.atlassian.jira.component.ComponentAccessor
def whichDate = "StartDate"
def sprintField = ComponentAccessor.getCustomFieldManager().getCustomFieldObjectByName("Sprint")
def dateToWorkWith
if (whichDate == "EndDate"){
    dateToWorkWith = issue.getCustomFieldValue(sprintField).endDate
}
if (whichDate == "StartDate"){
    dateToWorkWith = issue.getCustomFieldValue(sprintField).startDate
}
def result = dateToWorkWith[dateToWorkWith.size()-1]
if (result == null){
    return "No Date Information"
}
result

If you have any questions about this or need additional assistance, please feel free to contact us via support-team@almworks.com.  We look forward to hearing from you.

Best,
David

[Charlie Misonne]

Hi David

Thanks for your detailed answer and the script.

I'm luccky enough to have sciptrunner on that Jira instance :-)

Cheers

Charlie

[entelexeia]

How do I do this with Jira Cloud?

[Nicholas Ellis _ALM Works_]

This answer is a bit old, this is much easier to do now.  On cloud (or Server/DC) you can now do a very simple formula like so:

sprint.startDate

sprint.endDate

Here is the relevant documentation if you'd like to learn more: structure cloud formula documentation

Cheers,

Nick [ALM Works]

[Nicholas Ellis _ALM Works_]

@entelexeia 

On cloud (or Server/DC) you can now do a very simple formula like so:

sprint.startDate

sprint.endDate

Here is the relevant documentation if you'd like to learn more: structure cloud formula documentation

Cheers,

Nick [ALM Works]

[Vesa Purho]

Do you know if it is possible to access the sprint start and end dates from the parent if I group the issues by sprint? 

So I group by sprint, and for each issue under that group, I would like to pull the sprint start and end dates from the group. This is relevant in the situations when the issue has multiple sprints (it has been spilling from sprint to sprint) and I would like to just handle the start and end dates of the sprint the issue is grouped under.

[Stepan Kholodov _Tempo_]

Hello @Vesa Purho 

You can display the parent Sprint's Start or End date with a formula like this on Server/Data Center:

parent{sprintstartdate}
where sprintstartdate variable should be mapped to the Sprint Start Date attribute.

and this formula on Cloud:

sprint.filter($.name = parent{split(summary,": ").last()}).startdate

I hope this helps. If you need further assistance, please reach out to us directly at our support portal and we'll get back to you shortly.

Best regards,
Stepan Kholodov
Tempo (the Structure app vendor)