JIRA query for issues without parents

5
votes

I'm using a JIRA instance for which I'm not the admin, so I don't have the option of installing plugins. I'm trying to filter to find issues in a particular project that don't have a parent (aren't sub-tasks of something else), but I can't figure out a good way to do so. The following query returns issues with a particular parent with the ID 84, but I'm not sure how to tweak it to get issues with no parent:

project = FOO AND Status = Open AND parent = FOO-84
1
sqljira

1 Answers

7
votes

It doesn't seem to be possible since doing "parent = null" or "" will tell you that the parent field doesn't support empty value search.

However, to get a list of top level issues you can use the issueType field this way:

project = FOO AND Status = Open AND issuetype in standardIssueTypes()

To get a list of subtasks:

project = FOO AND Status = Open AND issuetype in subTaskIssueTypes()