JIRA : Need a filter to query all the tasks and stories that does not have parents

[Praveen Kumar G T]

Hi,

Our current hierarchy for our Projects is that we have multiple epics, Each Epic have multiple stories and Each Stories have either have multiple tasks or subtasks.

Even after our best effort, some create stories/tasks without linking them properly to an epic/story. We want to find this outliers, so I want a JQL query which will list all the stories and tasks that is DOES NOT have a parent

Regards,

Praveen.

[Daniel Deng]

Hi Praveen

For links with parent of epic, you can try jql "issuetype = yourissuetype and epic link is empty", which returns the issues that do not have an Epic as parent.

I am curious of how you linked a Task as a child of a Story. What is the type (in global issue type setting) of your Task, Standard or Sub-Task? All Sub-Task issue types should have a parent, therefore, you don't need to worry about it.

If your Task is Standard issue type, then it can only be a child of an Epic, unless you are using some plugin to create more hierarchies than Jira out of box.  

[Praveen Kumar G T]

I just made the task as a child of the story. You can make an task as a child of story or Epic.

Subtasks I dont have any issues as they are always created under a story.

So effectively I wanted all the tasks and stories that do not have an parent. Your query is able to get me all the tasks and Stories that are are not part of any Epic. But that can got from the section "Issues without epics". I actually want to find all the Tasks that does not have a parent. My Tasks are already part of Epic.

Like "Epic Link" do we have any field like "Parent" I actually see a field Parent but when I give it as Empty it says Parent field type cannot be compared with Empty

[Daniel Deng]

Hi Praveen

As I said, native jira does not support adding a Task as a child of Story. I guess you are using some plugins or just create a link and call it "parent/child"? It will be helpful If you can share how you made a task as a child of Story, and what are the valid values for custom field "Parent"? 

[Praveen Kumar G T]

I am just creating a link in the task and calling it parent

is their a way to list all the tasks who does not have the parent link

[Daniel Deng]

I did not see a way to do it by Jira out of box, but you can do it through plugins like this one https://marketplace.atlassian.com/apps/31399/jql-tricks-plugin?hosting=server&tab=overview