nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

Steven Brown_d98m0x

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

Accepted answers

All comments

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")

Screen Shot 2017-05-11 at 4.18.49 PM.png

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.

Chris Rees

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

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.

David Willson_qg3b8r

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_uvovr9

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

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira