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

Complex JQL queries - finding specific issues with parents, subtasks, etc.

mrdao

Hi, this is the query I'm trying to do:

All issues that are Bugs with 0 subtasks OR subtasks with Parents as a Bug.

The main reason with this is because our QA team has filed various sub-tasks within a Bug because they broke the parent bug even further. For me I just want to see the scope of the parent bug and how much stuff is within it. When I do an issue search, if I just search for IssueType "sub-task" it'll show all my Stories subtasks. If I just do Bugs and sub-tasks, it'll also show the parent bug in my list as well as the children sub-tasks separately and that gets confusing.

Any ideas?

Accepted answers

JamieA

This is pretty similar to this question, but simpler.

To find Bugs without subtasks:

issueFunction not in hasSubtasks() and issuetype = Bug

To find subtasks of Bugs:

issueFunction in subtasksOf("issuetype = Bug")

You can combine these to create:

(issueFunction not in hasSubtasks() and issuetype = Bug) OR issueFunction in subtasksOf("issuetype = Bug")

All comments

JamieA

This is pretty similar to this question, but simpler.

To find Bugs without subtasks:

issueFunction not in hasSubtasks() and issuetype = Bug

To find subtasks of Bugs:

issueFunction in subtasksOf("issuetype = Bug")

You can combine these to create:

(issueFunction not in hasSubtasks() and issuetype = Bug) OR issueFunction in subtasksOf("issuetype = Bug")

mrdao

Thanks for that. Any ideas on how to do it witout the extra plugin? Was trying to avoid using those since I don't have access to install.

Nicolas Casel

Thanks Jamie.

Actually the query you wrote:

issueFunction not in hasSubtasks() and issuetype = Bug

helps me getting all subtasks except the ones related to a Bug. I get it like this:

project = EXCTDWHI AND issuetype in (Epic, Spike, Story, Sub-task, Task) AND NOT issueFunction in subtasksOf("issuetype = Bug")