Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

What is JQL to exclude unrelated subtasks?

Victoria Luskin
Contributor
May 24, 2023

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

 

 

1 answer

0 votes
Aron Gombas _Midori_
Community Champion
May 24, 2023

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

Victoria Luskin
Contributor
May 24, 2023

@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_
Community Champion
May 24, 2023

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

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events