JQL query to return issues without parents

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."

1 answer

4 votes

Answer accepted

Try this:

project = TEST and issuetype in standardIssueTypes()

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

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

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Like • Sebastien Samson likes this

I think this page is what you want.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

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

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.