How can I obtain the Sprint Start Date(s) associated with an issue

[lhegde]

I would like to find the sprint start date(s) associated with an issue. For instance if an issue was part of multiple sprint start dates, I want to find all the sprint start dates for sprints the issue was involved in during an active sprint. I am trying to ultimately find the earliest active sprint that the story was part of / committed to.

Any idea on best approach?

[Prachi Bolar]

HI Ihegde,

Welcome to community!

Unfortunately, it is not possible to search issues based on the start-date and end-date of the actual sprint.

You can use the API : https://developer.atlassian.com/cloud/jira/software/rest/api-group-sprint/#api-rest-agile-1-0-sprint-sprintid-issue-get

Returns all issues in a sprint, for a given sprint ID.

Thank you,

Prachi

[Bill Sheboy]

Hi @lhegde -- Welcome to the Atlassian Community!

Where are you trying to do this in Jira?  That is...

There is nothing built-in for JQL to support querying issues in that way.  There may be marketplace addons for JQL which add this searching capability.

An automation rule could be used to get the data, perhaps creating an email report, or setting a custom field for later use.

For example, you describe wanting to find the earliest active sprint date in which a story was assigned.  That could be returned in a rule with:

{{issue.sprint.startDate.min}}

If you provide more information about when / how you want to capture this information, the community may offer more details.  Thanks!

Kind regards,
Bill