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

JQL functions to return issues from just closed sprint

sowjanya gondi

I need a JQL function that captures all issues that were part of just closed/latest closed sprint. This is to prepare Sprint completion report.

closedSprints() function gives issues from all closed sprints. I want to restrict it to one sprint which is just closed. Do we have a function for this?

Thank you.

Accepted answers

Ollie Guan

Hi @sowjanya gondi ,

You need to install ScriptRunner for Jira to extend this query.

Shows issues that are members of the last completed sprint.

previousSprint(board name)

https://scriptrunner.adaptavist.com/latest/jira/jql-functions.html#_completeinsprint

All comments

Ollie Guan

Hi @sowjanya gondi ,

You need to install ScriptRunner for Jira to extend this query.

Shows issues that are members of the last completed sprint.

previousSprint(board name)

https://scriptrunner.adaptavist.com/latest/jira/jql-functions.html#_completeinsprint

sowjanya gondi

Thanks a lot @Ollie Guan. I was actually looking for options outside of any plugin. Looks like Plugin like Scriptrunner would open up wide range of reporting capabilities. Will work towards obtaining it.

sowjanya gondi

Hi @Ollie Guan,

Are there any other Plugins you would recommend for Sprint Completion report? so that I can do a comparative study? Helps me understand what other top plugins are in the market that can do this job for us and select the most appropriate?

Also, about the pricing aspect. Would you know if they charge for the all the JIRA users or just the users who use this plugin for example: JIRA Administrators.

Thanks a lot!

Ollie Guan

Hi @sowjanya gondi ,

Most plugins are charged according to the same number of authorized users as Jira.

Cloud apps are sold as a monthly or annual subscription. You are eligible for support and automatic version updates as long as your subscription is active.

When your subscription renews each month, you are automatically billed for apps based on the number of users in your instance.

You can enter keywords according to your needs and select plugins by Top selling.

https://marketplace.atlassian.com/addons/app/jira/top-selling?hosting=cloud

Welcome!

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

Quick Links

Find more posts tagged with

jira

cloud

jira-cloud

jql

function