You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Join now to unlock these features and more
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?
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?
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.
We're you able to find a solution? If so please share it to help other community members who might have the same problem.