What JQL can provide me with Issues added after the start of the current sprint?

[Kyle Dengler]

How can I query Issues added after the start of the current sprint? Or added after the start of a particular sprint?

[Dave Liao · Accepted solution]

If you have ScriptRunner on your Jira instance, use the JQL function addedAfterSprintStart.

An example query would look like:

issueFunction in (addedAfterSprintStart(666))

where 666 would be the board ID with your active sprint. 😈

Related doc: https://docs.adaptavist.com/sr4js/latest/features/jql-functions/included-jql-functions/sprint

(for anyone else reading this, ScriptRunner for Jira Cloud has this feature too!)

[Kyle Dengler]

This worked for me! 

Additionally are you able to use CurrentSprint or OpenSprints in the following way?

issueFunction in addedAfterSprintStart("Sprint Board", openSprints() ) 

instead of

issueFunction in addedAfterSprintStart("Sprint Board", "Sprint Name") 

[Dave Liao]

Good follow-up question!

You'll need to nest another issueFunction in dealy-o there.

Check out this post: https://community.atlassian.com/t5/Jira-questions/Proper-syntax-for-doing-quadruple-nested-issueFunction-JQL/qaq-p/1647631

I'm actually experimenting to see what the exact JQL is, because I'm curious myself...

[Dave Liao]

If you don't have ScriptRunner, read this thread and be depressed. There's no JQL for that (yet?).

Workaround: You can look up the Sprint Report for the sprint you want, on-demand. There'll be an asterisk (*) next to each issue added after a sprint start.

Related doc: https://confluence.atlassian.com/jirasoftwareserver/sprint-report-938845689.html