What is JQL to exclude unrelated subtasks?

Question

Hello,

I need to fetch to the scrum board all items with no Epics.

This JQL includes all required items along with the subtasks from the Stories which don't meet the criteria ""Epic Link" is EMPTY (it brings subtasks only without its parent).

type != Epic AND "Epic Link" is EMPTY

How can I exclude all irrelevant subtasks?

Thanks,

Victoria

Aron Gombas _Midori_ · Answer

Subtasks inherit the epic from their parent (or in other words the subtasks "Epic Link" is always empty), so to rephrase your problem: you want to get all issue without an epic and their subtasks. Is that correct?

If so, you will need a JQL sub-query for that what is not supported by Jira Cloud out of the box. Or if you use Jira Advanced Roadmaps, then it supports some additional JQL functions that allow searching through the hierarchy...

Victoria Luskin · Answer

@Aron Gombas _Midori_ thank you for your prompt response

It excludes all subtasks from the board.

I am trying to get subtasks along with their parent Story, which meets criteria "Epic Link" is EMPTY.

Any idea?

Thanks

Aron Gombas _Midori_ · Answer

Use this:

type not in ("Epic","Subtask") AND "Epic Link" is EMPTY

As you see, the idea is to exclude listed issue types from the board. (If you have multiple, or differently name subtask types, you need to adjust the list, but it is trivial.)