In JQL is there a function that returns the start date of a given sprint?

Chris Rees

I'd like to report on Story-Bugs (subtask issue type) that were created in the current sprint, not just exist in the current sprint.

 

Is there a function that I can use to compare the story-bug's creation date with the sprint start date, e.g.

 

project = 'ABC' and fixVersion in (1.2.3) and sprint = 283 and issuetype in subTaskIssueTypes() and createdDate > sprintStartDate(283)

 

where the comparison is;

createdDate > sprintStartDate(283)

Alexey Matveev

Hello,

You would need an add-on for it.

If you are on Jira Server/Data Center, then you could use the Power Scripts add-on:

https://marketplace.atlassian.com/apps/43318/power-scripts-jira-script-automation?hosting=cloud&tab=overview

With this add-on you could write a JQL query like this:

'createdDate > sprintStartDate(283)',<span>&nbsp;</span>'<span>project = ABC and fixVersion in (1.2.3) and sprint = 283 and issuetype in subTaskIssueTypes()</span>')key in silJQLExpression(