How can i find each team member's subtask by their original estimate in a gadget?

Question

I want to see each team members original estimated times totally in current sprint.

I use this query but I can't group it by "assignee" to reach the total original estimated time by each person. unfortunately, pie chart shows the result by count of issue type but I need by sum of original estimate.

project in (XXX) AND Sprint in openSprints() AND issuetype = Sub-task

Rahaleh Rajabi · Answer

Thanks for your response

Nic Brough -Adaptavist- · Answer

You don't.  There's a couple of reasons -

First, sub-tasks do not have sprint estimates, because they're not sprint-items themselves, they are a part of their parent.

Second, sub-tasks do not have a sprint, because they are part of a story and hence "in a sprint" as part of the story.  There's a weakness in Jira in that it does not cascade that down, so "issue type in subtasktypes and sprint = X" is never going to find any sub-tasks, but even if it were to work, the sprint would still be set by the parent.  You'll need to infer the sub-task list from the list of stories in the sprint.