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; } } }

JQL to fetch open parents with all closed sub-tasks

Manoj Kumar Gangwar

I have Sciptrunner and tried many JQL's but still not getting correct result.

My requirement is When all sub-tasks are Resolved for a parent and parent status should not be Resolved.

I tried below JQL's

project = RQM AND issueFunction in parentsOf("status in (\"Open\", Pending, \"In Progress\") AND Resolution is Empty") AND issueFunction not in subtasksOf("status != Resolved")

project = "RQM" and issueFunction in subtasksOf('status not in (Closed, Canceled, Resolved)') AND Status = Resolved

This one is close enough but still fetching some parents which subtasks have pending status.

Accepted answers

Manoj Kumar Gangwar

@Joseph Chung Yin

I figured it out and below JQL works perfectly form me.

project = RQM and statusCategory != Done AND issuefunction in hasSubtasks() AND NOT issuefunction in parentsOf("project = RQM and status not in (Resolved)")

All comments

Joseph Chung Yin

@Manoj Kumar Gangwar -

Give this a try.

project = RQM and issueFunction in parentsOf("project = RQM and resolution is not empty") and resolution is empty&nbsp;

This query should give you all the open parent issues where all of their subtasks are closed.

Hope this helps.

Best, Joseph

Manoj Kumar Gangwar

Still fetching the Unresolved Resolution subtasks for few parents.

Query returned total 6 issues. 3 are correct subtasks are resolved and parent is not resolved but for rest of 3 subtasks are resolved, open, pending status and parent is not resolved.

Manoj Kumar Gangwar

@Joseph Chung Yin

I figured it out and below JQL works perfectly form me.

project = RQM and statusCategory != Done AND issuefunction in hasSubtasks() AND NOT issuefunction in parentsOf("project = RQM and status not in (Resolved)")

Welcome!

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

Quick Links

Find more posts tagged with

server

jira-service-management

jira-service-management-server