How to display sprint Start,End Date in the issue filter columns?

[Mohamed Adel]

is there any way to display sprint start and end date while searching for issues ?

[Deleted user · Accepted solution]

Hi @Mohamed Adel,

Unfortunately Jira does not expose these values natively, however in a similar discussion users investigated the Script Runner add-on using the inSprint function. 

Jeff Curry, of Atlassian, mentioned using the advanced JQL functions openSprint() and closedSprint(). Though this will not display the exact dates of the sprint when querying issues. 

openSprints()

closedSprints()

Kristian Walker, of Adaptavist, has posted a script that should be able to give you a field for the sprint dates. If you need assistance with set up you should be able to reply to Kristian on the original post. He may be able to help you.

Hope this helps

[Mohamed Adel]

Thanks for your reply, 

Kristian's solution works for me. 

I added the scripted fields and now I can display them in the issue filter screen

Regards

[Chris Dennison]

Seems like a custom field or two could be created to capture the assigned sprint's start and end dates.  Since Jira tracks multiple sprints for those tickets that roll over to later sprints, the function would have to take the latest dates.  I have the feeling this would still be tricky to set up since the dates may not be standard fields, plus it would need to accommodate if the sprint dates were changed or the ticket is moved to another sprint.