Filtering on subtasks

Sally Sattary

I feel like what I want to do is really simple, but I can't crack it, does anyone have experience? 

When we're at the end of a sprint and starting to think about what we want to demo in the review, we want to know which stories only have sub-tasks left in review and/or done (e.g. they will completed by the end of the sprint). I've tried to write it out below, but not sure how I'd get it to work.

project = ADAPT AND (Type = story OR Type = bug) AND all subtasks(status = Review or status = done)) AND sprint in openSprints() ORDER BY status, updatedDate DESC

Essentially what we want is a list of stories we will need to demo

Thanks in advance

Jack Brickey

Hi @Sally Sattary , welcome to the community.

Let me see if I can assist here and understand your goal bit better. Your last sentence seems to capture your fundamental goal. You wish to be able to understand what issues are complete or likely to be complete at the time the sprained ends. This is defined by issues in either the Done column or the In Review column. Is this correct?

Assuming the above is indeed correct could you not simply query for those two statuses? Now I realize you're talking about sub tasks here which is fine and you can find those issues through a query however, I would also contend that you should be focused on stories only not subtasks. In the agile world, especially in Jira,  for a story to be complete, and therefore demonstrable, all sub-tasks should also be completed. Otherwise the story is considered incomplete and likely should not be demonstrated. Now this last bit is certainly debatable as one could argue that you could demonstrate how far you've come on the story.

with that said please consider the following JQL...

project = ADAPT AND sprint in openSprints() AND status in (done, "in review")