I need a jql query that will return all the stories in an epic and accumlate all the story points.

david jay mcgee October 10, 2023

I want to write a jql query that will return all the stories and their points from an epic. 

1 answer

0 votes
Trudy Claspill
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
October 10, 2023

Hello @david jay mcgee 

A JQL filter selects issues, it doesn't do calculations.

You can get all the issues for a given Epic using the JQL:

Parent=issue key for the Epic

What do you want to do with the sum of the story points once you have it?

Is this a recurring task you need to do?

Do you need to do this for multiple epics?

david jay mcgee October 10, 2023

I want to sum all the story points from all the stories in an epic, I have been trying to use issueFunction in aggregate Expression("total story points", "StoryPoints.sum()"), in jira issue advanced search, running jql. There the total is displayed at the top of the result set, when exported the total is displayed. 

But the query is selecting stories with a specific component. I guess I need to know is there a way to compound the queries like i would do for a sql query on data?

david jay mcgee October 10, 2023

The real issue is I need to take some jql classes. Not sure where to start here

Like Marc - Devoteam likes this
Trudy Claspill
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
October 10, 2023

There is training on native JQL capabilities in https://university.atlassian.com

However, issueFunction and aggregateExpression are not native capabilities of Jira Cloud. They must have come from a third party app that was added to your Jira instance.

So, you'll need to determine the app that was installed that added those capabilities. You may need to check with your Jira Administrators to find that out. If you share that information with us then we can perhaps provide some advice to you about the use/capabilities of that app.

Like Marc - Devoteam likes this
david jay mcgee October 12, 2023

Thanks to all. 

Trudy Claspill
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
October 12, 2023

We're you able to find a solution? If so please share it to help other community members who might have the same problem.

Suggest an answer

Log in or Sign up to answer