JQL to find Stories that have a Σ Remaining Estimate of more than X

[Steve Beauchamp]

Hi,

I'm looking for a way to return a list of issues that have a Remaining Estimate of more than 2w. This is easy if I'm looking at the remaining estimate for a single issue, by using: 

remainingEstimate > 8d

However, this will not return any Stories that have sub-tasks that bring the combined total estimate for the Story above the 2w threshold. The solution I am currently using employs an issueFunction found in ScriptRunner:

remainingEstimate > 2w OR issueFunction in parentsOf("remainingEstimate > 2w")
 

This is returning Stories with Sub-Tasks that have a combined remaining estimate of more than 2w, BUT it will only return issues that have an even number of weeks (e.g. Story that has a remaining estimate of 3w or more) - it will not return issues that are over the threshold by a fraction of a week (e.g. 2w 1d). I have tried changing the estimate value format (e.g. ... > 10d) but this doesn't work either. 

I'm thinking that this might be because of how Time Tracking is configured on our JIRA instance, but I'm looking for alternative solutions before I start messing with that, as this affects all projects in our instance globally. 

Any suggestions are welcome! :)

[Steve Beauchamp · Accepted solution]

**UPDATE**

In case anyone comes to this post looking for the same answer as me, I have found a solution that works!

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

[Carlos Trepeu]

I know this is an old post, but you are not calculating the sum of all the subtasks here. You are obtaining any subtask where remainingEstimate is greater than 10 days.

[Omprakash Thamsetty]

Hi @Carlos Trepeu @Steve Beauchamp I know this is old post but yes, I tried with the query Steve posted but it is not doing sum of all the subtask. It is returning only any one of the subtask has more than 10 days then that parent ticket showing. How I can get sum of all subtask ?

[Kian Stack Mumo Systems]

Have you tried looking base don the number of hours?

For example: remainingEstimate > 80h OR issueFunction in parentsOf("remainingEstimate > 80h") 

[Steve Beauchamp]

Yes, I have tried that. Unfortunately, I'm getting the same result .