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_ · Accepted solution]

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

[Kaushik Patel]

Thank you @Jack Nolddor _Sweet Bananas_ this helps.

One request, I want to identify sub-tasks with workratio between 80 and 100. Can you please modify query accordingly.

[Jack Nolddor _Sweet Bananas_]

Done :)

[Kaushik Patel]

Thank you @Jack Nolddor _Sweet Bananas_  for timely help.