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 query to return issues without parents

Christian Selbr

I want to write a JQL query that doesn't return any Sub-tasks. We have setup many different Sub-task types.

Basically, how do you do something like this?

Project = Test AND issue in notASubtask()

Is there an easy way to check in JQL if an issue has a parent?

When I run this JQL Query:

project = Test and parent = null

JIRA tells me:

"the field 'parent' does not support searching for EMPTY values."

Accepted answers

Jobin Kuruvilla [Adaptavist]

Try this:

project = TEST and issuetype in standardIssueTypes()

All comments

Jobin Kuruvilla [Adaptavist]

Try this:

project = TEST and issuetype in standardIssueTypes()

Serhii Riabovil

Good suggestion, but is there any way to find orphaned sub-tasks?

Gustavo Chaves

I think this page is what you want.

Michael Yu_8wgjn6

@Jobin Kuruvilla Thank you very much. It's useful for export parent id issue type.

Welcome!

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

Quick Links

Find more posts tagged with

jira

jql