JQL for last close Sprint

[Manikandan K]

Please let me know do we have any function to retrieve the values from previously closed Sprint using the script runner ?

[Tarun Sapra · Accepted solution]

The following function should be able to help you to

previousSprint

previousSprint(board name)

Shows issues that are members of the last completed sprint.

[Tarun Sapra]

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

[Manikandan K]

Thanks Tarun

When i use below query it returns the value

 issueFunction in aggregateExpression("Total Estimate for all Issues", "originalEstimate.sum()", "Remaining work", "remainingEstimate.sum()")  and sprint in (126)

But not for this one. What did i miss in my JQL

 issueFunction in aggregateExpression("Total Estimate for all Issues", "originalEstimate.sum()", "Remaining work", "remainingEstimate.sum()")  and issueFunction in (previousSprint("Olympians Board for Story (AA + BB+ CC+DD)"))

I dont want to update the query every Sprint

[Tarun Sapra]

What is returned by 

issueFunction in previousSprint(<your board name here>)

[Manikandan K]

When i run this query 

issueFunction in (previousSprint("Olympians Board for Story (AA + BB+ CC+DD)")

I get no issues found. Is anything wrong in it ?

[Tarun Sapra]

Are you entering the correct board name as you have to just enter the board name and whats "AA , BB, CC, DD" . What kind of naming is this?

Also please validate in the board that you have an closed sprint in the board as the "previousSprint" returns issues from last closed sprint.

[Manikandan K]

I have updated the board name  with below 

issueFunction in (previousSprint("Olympians_Board_for_Story"))

Still it shows no issues found. I have reports and velocity chart being populated for this board

If the board name is incorrect it throws an error message. It seems to be an issue with script runner 

[Manikandan K]

I found the issue in my jql. 

When i exclude "(" in front of the previous sprint it worked. Thanks Tarun

issueFunction in previousSprint("Olympians_Board_for_Story")

[Tarun Sapra]

Good to know that it's now working. Please upvote/accept the answer if it works for you.

[Manikandan K]

Thanks. I did.

[Wilson Faure]

I tried this but did not work for me. do I need to have those functions enabled in my Jira install? we use JIra server version

[Muhammad Waqas Osmani]

@Tarun Sapra 

when I write my query, I get this reponse:

Unable to find JQL function 'previousSprint()'.

[Omar.Samad]

same for me. I guess we will need to use some jira Ad-Ons to have these functions?

[Omar.Samad]

when I write my query, I get this reponse:

Unable to find JQL function 'previousSprint()'.

[Dave F]

previousSprint() is an Adaptavist Scriptrunner plug-in function.  See the link just under the Answer text above