Display LAST Sprint Number in Structure Column

unknown

I need to build a report that, among other things, needs to show the following items:

• I want to see the current sprint number the story is assigned to in a Structure column.  I found several column headers that look as though they would give me what I'm looking for, but either they are blank or they show the full history of the sprints the stories have been a part of.

              

 

• I want the Sprint Start Date to appear in the structure.  Again, there are several columns that look like they'd work, but none of them populate.
• I want the Sprint End Date to appear in the structure.  Just as above, many options, none work.

         

I have to imagine this is completely possible and I'm just an idiot who hasn't been able to figure it out, but I feel like I've tried everything, and it's like the columns aren't associated to the fields in the boards, sprints, or stories.

 

This is all I want:

Thanks in advance!

Michael

Egor Tasa [ALM Works]

Hi Michael,

It is not yet possible to find exactly the last sprint, using Structure, but it may become possible in the future, when we introduce array handling in formulas. And Sprint start and end dates are not available either, but may become available later. In the meantime, you can use ScriptRunner (or similar app) to create custom scriptable fields that would retrieve sprint dates. Here are a couple of examples:

import com.atlassian.jira.component.ComponentAccessor
import com.atlassian.jira.issue.Issue

def customFieldManager = ComponentAccessor.getCustomFieldManager()
def sprintCf = customFieldManager.getCustomFieldObjectByName("Sprint")

return issue.getCustomFieldValue(sprintCf)?.startDate?.first()?.toDate()

And

import com.atlassian.jira.component.ComponentAccessor
import com.atlassian.jira.issue.Issue

def customFieldManager = ComponentAccessor.getCustomFieldManager()
def sprintCf = customFieldManager.getCustomFieldObjectByName("Sprint")

return issue.getCustomFieldValue(sprintCf)?.endDate?.first()?.toDate()

Regards,

Egor