I want to write a jql query that will return all the stories and their points from an epic.
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?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
The real issue is I need to take some jql classes. Not sure where to start here
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
We're you able to find a solution? If so please share it to help other community members who might have the same problem.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.