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

[david jay mcgee]

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

[Trudy Claspill]

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]

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]

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

[Trudy Claspill]

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.

[david jay mcgee]

Thanks to all. 

[Trudy Claspill]

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