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:

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