Query only open stories in sprint

[Daniel Winter]

Hey, I'm trying to create a query that let's me hide all the closed Stories of the Active sprint in the Scrum Board.

So I would like to see Only Open/In Development Stories and all their Subtasks(not filtering by any status)

This kind of works...

issuetype = Story and status not in (Closed,Resolved)

...but then I will not see any subtasks 

If I just filter by status then I will filter out the Closed/Resolved Subtasks as well..

[Udo Brand · Accepted solution]

With standard JQL you can't do it. But if you have Scriptrunner installed you can use:

(issuetype = Story and status not in (Closed,Resolved)) or issuefunction in subtaskOf("issuetype = Story and status not in (Closed,Resolved)")