Need to create query to list sub-tasks for which logged Hrs approach Estimated Hrs

Kaushik Patel

We want to know in advance when sub-tasks logged Hrs are about to reach Estimated Hrs, so we can come to know if the sub-task is going to take more Hrs than estimated in advance.

We use ScriptRunner for advance JQL queries. But if we can have query in native JIRA, then it's fine too.

We want to create query to list sub-tasks when they are at 0.8*Original Estimate or 80% of the Original Estimate with choice of status selection to exclude the completed sub-tasks.

(irrespective of sub-task issue type)

The input of the query will be comma separated parent tasks. And for those parent tasks only the sub-tasks should be listed satisfying above criteria.

Thanks,

Kaushik.

Jack Nolddor [Sweet Bananas]

Hi,

What about this?

issuetype in subTaskIssueTypes() AND workratio >= 80 AND workratio <= 100 AND statusCategory NOT IN Done 

 

Note that you can no order issue by their parents OOTB.

Regards