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.

[Ollie Guan · Accepted solution]

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