nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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?

Accepted answers

bravedj

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

All comments

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

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

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

Nicole Downes

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

Ray_nz50ke

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

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

cloud

jira-cloud