What JQL query is used to see issues added to a Sprint after a given date?

[Steven Brown]

Hi - I need to keep track of issues being added (or ideally removed) from a Sprint after a fixed date in time.  I've searched the forum and found the ability to track issues added after the start of the Sprint, but I need the flexibility to change the search date so for examples, what issues were added in the last weeek, last 24 hours, etc.  It would also be great if I could track issues being removed (having the Sprint removed from the Sprint field).

We use iTrack powered by Atlassian JIRA 7.2.7.

Thanks

Steven

[Chris Rees]

Vote for JSWSERVER-20097 to have this built into JIRA Server, or JSWCLOUD-16523 for JIRA Cloud, by default.

[Chander Inguva]

Hey Steven,

If you do have Script Runner installed

JQL Syntax:
project = "<Project Name>" AND issueFunction in addedAfterSprintStart("<Board Name>","<Sprint Name>")

Example:
project = "Corporate IT" AND issueFunction in addedAfterSprintStart("Sprint_Planning_Corporate IT","CIT-Apps: 17.2.2")

Cheers

Chander

[Meenakshi Khanna]

I don't have Script Runner. What is that ?

I used JQL issueFunction in addedAfterSprintStart and it seems to work. I hope I am not missing something here.

[David Willson]

Worked great!

Script runner is an app you pay for and install into Jira. You can find it in the Atlassian Marketplace as "ScriptRunner for Jira". I use datacenter (ie not cloud)

Once installed the JQL mentioned above works great. (mind you I didn't test it without script runner installed)

David

[stephanie_hart]

I do not have access to scriptrunner, does someone have alternative way of doing this with JQL?

[SUVARNA Dixit]

IssueFunction is not working at my JQL. any other alternative? 

[Idiyana Salim]

Hi, 

I think i'm looking for something similar to @Steven Brown . I was able to search for issue that added into sprint after the sprint started using issueFunction in addedAfterSprintStart(). But i'm looking for more details info like issues added for today only.