Sprint to show subtasks

[Simon Jackson]

We are trying to build a filter to show only the active subtasks in a sprint.

For example, a parent ticket has 3 subtasks

Task completed in previous Sprint so that leaves 2 tasks for the newsprint

How over using something like the below to filter the data we still see the closed tasks

project IN (ANA, NTO, INFDEV, PTR, SCL, SGI, TDT)

AND issuetype IN (Dev, Review, Test, Sub-task)

AND sprint = 242

ORDER BY created DESC

any thoughts pelase

[Stephen_Lugton]

@Simon Jackson try adding

AND statuscategory != Done