Using JQL, how do I find points for all stories under some epics having labels "XYZ"

Sanjay Munsi

I am surprised with how I can do this with JQL. 

 

In JIRA world, epics have features and features have stories. I am trying to do the following.

1) Find all epics with label: "Physics" and "Math"

2) Look at all the features for each of these type of epics and then the stories under all these features and story points. I have to do this both "Physics" and "Math" epics.

3) Aggregate all the story points. That will give the level of efforts for each kind of epic.

 

Can someone please let me know how I can do these all using JQL? Thanks in advance for your help.

 

Trudy P Claspill

Hello @Sanjay Munsi 

Welcome to the Atlassian community!

You cannot accomplish that with the native JQL functionality because it would require using subqueries. Are you open to using third party apps?

An alternative is to use automation to total up the story points from the stories to their parent Features and store the value there in a custom field, then total up all those values in the Features and store the information in their parent Epics. Then you would be able to create a JQL to retrieve the desired Epics and simply display the field that carried the tallied story points.