Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Celebration

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root

Avatar

1 badge earned

Collect

Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!

Challenges
Coins

Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.

Recognition
Ribbon

Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!

Leaderboard

Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,552,433
Community Members
 
Community Events
184
Community Groups

What is JQL to exclude unrelated subtasks?

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 Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
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.)

@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 Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
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