Does natively support dynamically updating JQL filters with new closed sprint IDs.

[Sriram]

Currently I am adding the sprint ID's manually in jql filter. Is it possible to update the filter automatically. like if i have some of the closed sprint id's and if new sprint is completed it needs to be added to the jql filter automatically. So in the dashboard filter by using two dimensional I can be able to see the completed sprints.

[Walter Buggenhout]

Hi @Sriram and welcome to the Community!

The following JQL automatically lists all completed sprints. It doesn't require updating:

sprint in closedSprints()

Obviously, you can combine this with other statements, e.g. Project = "Your Project" AND sprint in closedSprints()

Hope this helps!

[Sriram]

HI @Walter Buggenhout ,

Thanks for your response!
But the above query didn't work in our scenario.
Error : The '{sprint in closedSprints()}' clause in your search matches too many results. If a clause returns too many results, the entire search will fail. Please refine or remove the clause and try the search again.

However we when adding the sprints with there id's it working.

[Walter Buggenhout]

That is, most likely, because "sprint in closedSprints()" pulls in sprints from all boards in your entire Jira instance.

As I mentioned, narrow down your search to make the data set smaller. You could do this by e.g. starting from the board filter of your sprint board and add the sprint in closedSprints() clause to that to only return issues in sprints on your board. Or, as I added in my initial answer, narrow down the returned issues by project. I'm sure you can find a way to fix this 😛