JQL query to return issues without parents

[Christian Selbrede]

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

[Jobin Kuruvilla [Adaptavist] · Accepted solution]

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]

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