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-search for sub-tasks in a parent tasks having all other sub-tasks closed

Andrey Tyupov

Hello,

Is it possible to search with JQL for a sub-task where all the other sub-tasks of a parent task except the one being searched for have the status 'closed'?

For example, I have the following structure of issues

- Parent Task1

---Sub-task 1.1 - 'Label1' - Closed

---Sub-task 1.2 - 'Label2' - Open

---Sub-task 1.3 - 'Label3 - Open

- Parent Task2

---Sub-task 2.1 - 'Label1' - Closed

---Sub-task 2.2 - 'Label2' - Closed

---Sub-task 2.3 - 'Label3' - Open

So I want to find that sub-task 2.3. Is it possible with JQL?

Accepted answers

Igor Sereda [ALM Works]

Hi Andrey!

Just in case you are using Structure add-on and have this hierarchy as a structure, you can use S-JQL filter like

[status = Open] AND NOT (sibling of [status = Open])

Or, if you need it in a JQL statement somewhere,

issue in structure("my structure name", "[status = Open] AND NOT (sibling of [status = Open])")

Let me know if you need further help with this!

Igor

All comments

Alexey Matveev

It is not possible out of the box. I think you would need to write your own JQL function with Power Scripts, ScriptRunner or your own plugin.

Nisha Hajamohideen

Hello

Have you tried project = "PROJECT NAME" and type = Sub-task and resolution is EMPTY ?

this will list all open subtasks in your project.

If you want just the list under specific parent ticket try:

Resolution is EMPTY AND parent in (ISSUEKEY)

Igor Sereda [ALM Works]

Hi Andrey!

Just in case you are using Structure add-on and have this hierarchy as a structure, you can use S-JQL filter like

[status = Open] AND NOT (sibling of [status = Open])

Or, if you need it in a JQL statement somewhere,

issue in structure("my structure name", "[status = Open] AND NOT (sibling of [status = Open])")

Let me know if you need further help with this!

Igor

Andrey Tyupov

Hi Igor,

Yes we are using Structure here.

I have tried it and it works just as we need.

Thanks a lot for the help!

Andrey

Igor Sereda [ALM Works]

Great! Happy to help.

Igor

Surendar

I need to query open subtasks where parent status is in Done.

I don thave parentsof function permission or functionality in our project.

Welcome!

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

Quick Links

Find more posts tagged with

jira

jira-software

jql