Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

JIRA query for issues without parents

Tags:

sql

jira

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
like image 202
Tyson Avatar asked Aug 28 '12 22:08

Tyson


People also ask

How do I see all child issues in Jira?

For child issues of an issue from a specific hierarchy level in Portfolio for Jira, type issuekey in childIssuesOf("EX-000").

What are the two ways to search for issues in Jira?

Basic and Advanced Searches There are two types of searches in Jira: basic and advanced. Basic searches, like the ones above, present you with a set of forms that you can fill in, such as Project name, Issue Type, Status, and Assignee. Basic search can be useful for getting a high-level view of your issues and status.

Can a Jira issue have multiple parents?

In Portfolio for Jira an issue can only have one single parent issue. So an Epic can be assigned to only one single initiative through a parent - child relationship.

What does != In Jira mean?

The " != " operator is used to search for issues where the value of the specified field does not match the specified value. (Note: cannot be used with text fields; see the DOES NOT MATCH (" !~ ") operator instead.)


1 Answers

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()
like image 93
Allov Avatar answered Nov 27 '22 23:11

Allov