JQL to find parent ticket which are having more than 10 hours of sum of all Subtask

Omprakash Thamsetty

I need to get result of Task which are more than 10 hours of sum of all Subtask original estimate. 

 

I have this but it is not sum of all subtask. It is just giving me the output if there is any one subtask has more than 10 hours. 

 

issueFunction in parentsOf("issuetype = sub-task AND remainingEstimate > 10h")) 

Atlass Monster

Many Jira users prefer to Edit the Story Point of the parent task or to user Custom Field for this purpose. Atlassian have nice template for it.

https://www.atlassian.com/software/jira/automation-template-library/sum-up-story-points

What you can do is to set a custom field for your project and assign it to the task types that need it. With JQL you can simply seek which parent tasks have their Sum StoryPoint fields above 10.