Get the Stories & Subtasks with Status not in Done or Done in current sprint

JOY

Hi,

 

I'dlike to query the Stories & Subtasks in open, future sprints and in blacklog which status is not in (Done, Won't Fix) or Done in open/future sprints.

When I tried: 

project = TIME AND issueType in (Story, Subtask) AND (Sprint in (futureSprints(), openSprints()) OR sprint = EMPTY) ORDER BY Sprint ASC, issueType ASC

It gets all the subtasks even they are Done and not in open or future sprints.

If I tried:

project = TIME AND issueType in (Story, Subtask) AND Sprint not in closedSprints() ORDER BY Sprint ASC, issueType ASC

It will not get the subtasks although all of our subtask has sprint field.

Walter Buggenhout

Hi @JOY,

If you want to exclude done items, you'll need to make that explicit in your filter statement. Have you tried something like this?

project = TIME AND issueType in (Story, Subtask)
AND (Sprint in (futureSprints(), openSprints())OR sprint = EMPTY)
AND Status not in (Done, "Won't Fix")

 Hope this helps!