Query to get sum of all story point in sprint by passing the board id

[Vijayakumar Ramasubbu]

The below query gives me the sum of all story points in the sprint. I want to update this by passing the board id and current sprint.

issueFunction in aggregateExpression("Total Story Points", "storyPoints.sum()") AND Sprint = <Sprint id>

[Danut M _StonikByte_]

Hi @Vijayakumar Ramasubbu,

It might not be possible to create such JQL, because the JQL does not allow you to filter by board.

But there are better and easier ways to see the number of story points in a sprint. For example, with the Team Velocity gadget offered by our Great Gadgets app you can see the sum of all story points in all the sprints of a specific board, including the current (active) sprint!

All you have to do is to configure this gadget to use your board, check the option to include the active sprint(s) and to display only the Final Scope series. As a result you will get the information that you are looking for, in real time.  

Hope this helps.

Danut.

[Nic Brough -Adaptavist-]

This does not help, you have not read the question.

[Nic Brough -Adaptavist-]

Welcome to the Atlassian Community!

A Scrum board shows the current sprint, so you don't need the board ID and Sprint to do this.  You just look at the sprint.  

[Vijayakumar Ramasubbu]

How can i get the current sprint id with JQL. I have more boards under one project, it is time consuming to manually check for the sprint id on each board. If i can automate by passing sprint id it should be helpful

[Nic Brough -Adaptavist-]

JQL only gives you a list of issues that matches the question you ask with it.

If you want to see the sprints issues are in, then you need to use a view of the JQL results that include it. 

The most obvious one is the "issue navigator", which is where you land when you run a search or filter.   Add "sprint" as a column in the issue navigator to see it.

Please bear in mind that a board and a sprint are very different things, and there not a 1:1 relationship between them.