Finding defects created within the current sprint

Question

I am looking for two separate queries to track defects that were created in the current sprint and defects that rolled over from the previous sprint. We recently update to Jira Cloud and lost the ability to write queries like "created in openSprint()" or "created in previousSprint".

Currently, I have these queries on dashboards set by our sprint dates. However, I have to update these manually after each sprint. Any thoughts?

Daniel Turczanski - JQL Search Extensions · Answer

Hi @[deleted],

With standard JQL, you can only get a list of issues that belong to closed, open, or future sprints - regardless of the board they belong to.

You can also export the issues to Excel for further processing. This works if you want to do a one-off analysis.

Standard JQL doesn't easily allow it, but you can find the results quickly using our professional indexing service JQL Search Extensions

After you install the app, you can simply search:

issue in previousSprint("ACME board")

Check out the documentation to see more examples.

I hope this helps!
Daniel

Bill Sheboy · Answer

Hi @[deleted]-- Welcome to the Atlassian Community!

I do not believe you can perform those queries with out-of-the-box JQL with Jira Cloud.  It may be possible with marketplace addon apps.  Given your apparent switch from server/data center, your company may have already done this; please check with your site admin to learn more on that.

As a work-around, you could use custom fields and automation for Jira rule to detect the condition.  For example a field with "Created During Sprint", and then check that value in your dashboard query.

Another more complicated work-around is to use the filters you have created for your dashboard and use an automation rule which calls the REST API when a sprint starts to dynamically update the filters.

Kind regards,
Bill