Query not returning results on closed subtasks

[Nisha Patel]

When I run this JQL query, I do not get any results

sprint = 51 AND issuetype = Subtask AND status = Closed

The sprint above is closed, I have 2 sprints open. There are multiple sub-tasks that are in the closed state.

[Trudy Claspill]

Hello @Nisha Patel 

Welcome to the community.

Do you get results if you break the query down?

Do you get results for ...

sprint=51

Do you get results for ...

sprint = 51 AND issuetype = Subtask

Are you working with issues in a Team Managed project or a Company Managed project? Typically the default name for a subtask in a Company Managed project is "Sub-task" (with a hyphen) and in a Team Managed project the default name is "Subtask" (without a hyphen). Are you sure you have the correct issue type name?

If you get results for ...

sprint = 51 AND issuetype = Subtask

...but not for

sprint = 51 AND issuetype = Subtask and status = Closed

... then you need to check if "Closed" is a valid status for the Subtasks, and if you actually have any subtasks that are currently in the Closed status that were also assigned to sprint 51.

[Nisha Patel]

Hi Trudy,

Thanks for the quick response!

I do get results for Sprint = 51 but no results for issueType = Sub-task and one result from sprint = 51 AND issuetype = Subtask.

The one item that populates was previously a Story and was changed to a Subtask. I have MANY subtasks that are in the closed status. All subtasks were created by using the Create a Child Task button.

[Nisha Patel]

When I run the query Sprint = 51 the only subtasks that populate are ones that were originally a Story and changed to a subtask

[Trudy Claspill]

Subtasks are not assigned to sprints separately from their parent issues. The subtasks should be inheriting the sprint values from their parents.

Were any of the standard level issues in Sprint =51 populated with child subtasks, and are those child subtasks currently in a Closed status?

Do you know of an existing subtask that is currently Closed that you believe should be returned in the query results? Can you provide a screen image of that subtask showing its status and its Sprint field?