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()

[Ray]

Hi, 
How would you do this to find uassigned subtasks within a story?

[Nicole Downes]

For advanced search options go to Advanced search reference - JQL functions | Jira Work Management Cloud | Atlassian Support

[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.

[Nicole Downes]

In Jira cloud, the following is available without Scriptrunner:

• Find issues and sub-tasks in the epic DEMO-123:
  parentEpic = DEMO 123

• Find issues and sub-tasks in the epic DEMO-1 or SAMPLE-4:
  parentEpic in (DEMO-1, SAMPLE-4)

For other advanced search options go to Advanced search reference - JQL functions | Jira Work Management Cloud | Atlassian Support