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; } } }

How can I view tickets closed in last sprint?

Radha Krishna Singh_39jk01

I need a dynamic filter, which can show the tickets that have been closed in last sprint to create a dashboard.

Comments

Jack Brickey

JQL can’t get you there. If you happen to have Scriptrunner you could use the following

previousSprint(board name/ID)

Daniel Turczanski - JQL Search Extensions

Hi @Radha Krishna Singh,

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

Radha Krishna Singh_39jk01

Thanks @Daniel Turczanski - JQL Search Extensions
I was looking for something free, have tried this filter

statusCategory = Done AND resolved >= "-2w 13d" AND Sprint in closedSprints()

This is solving the issue as of now.

Radha Krishna Singh_39jk01

Thanks @Jack Brickey , I was looking for a free solution.

Welcome!

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

Quick Links

Find more posts tagged with

agile