Forums

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

Can I include Epics that have a certain team selected and those that are empty?

Deleted user December 6, 2023

I have a filter that I'm working on to display our epics. I had excluded two teams I didn't want it to display using JQL, but it was also excluding the epics that don't have teams assigned. I need to have those epics without a team field returned. I need help writing to JQL to achieve this. I tried some different things with Team is Empty, but I couldn't get what I needed. 

This is my current JQL with the team logic removed.

project in (X, X, X) AND issuetype = Epic AND createdDate >= startOfYear() AND status != "Will not do"

1 answer

1 accepted

1 vote
Answer accepted
Trudy Claspill
Community Champion
December 6, 2023

Hello @[deleted] 

Try this:

project in (X, X, X) AND issuetype = Epic AND createdDate >= startOfYear() AND status != "Will not do" AND (Team is empty or Team in (X, Y, Z))

...specifying the teams that you do want to include, or try this specifying the teams you want to exclude:

project in (X, X, X) AND issuetype = Epic AND createdDate >= startOfYear() AND status != "Will not do" AND (Team is empty or Team not in (A, B, C))

Deleted user December 7, 2023

This worked, thank you! I couldn't figure out how to get the two states for Team to work together. 

Like Trudy Claspill likes this

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events