Query to pull User Stories with Sub-tasks status

[bravedj]

Greetings all!

Need some more help plz. I am trying to get the list of User Stories with "Sub-tasks status in (Done, Cancelled)". So it should pull only the count of User stories where the sub-tasks status in either Done or Cancelled.

am using below query, but doesn't pull anything.

project = JIRA AND "Epic Link" = JIRA-1 and issuetype = story and issueFunction in hasSubtasks() and (issueFunction in subtasksOf("status in (Done, Cancelled)"))

can you please help?

[bravedj · Accepted solution]

Got the answer!

project = Jira and "Epic Link" = Jira-1 and type = Story and not issuefunction in parentsOf("status != Done and status !=Cancelled") and issueFunction in hasSubtasks()

[Fazila Ashraf]

@bravedj  , if you are interested on returning the stories only, then you should use parentsOf instead of subtasksOf

That would return the parents (i.e., stories) where the subtasks are in the given status

[bravedj]

Thanks Fazila, yes parentsOf worked. thank you. plz see my exact query below.

[Afrida Islam]

Hey, I am tring to retrun the Subtasks in this case what to do?
I am struggling in filtering all the Subtasks != Done but their parent Stories = Done.