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

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Create a Filter that excludes a single epic and its issues

I have a project APT

I have an number of Epics in that project (APT-1, APT-3,  APT-16)

I have a number of issues of several types (stories, bugs, tasks) in those epics.

I wish to have a filter that shows me everything in that project except for Epic APT-16 and the issues inside it.

project = APT

Shows all issues, epics, etc. as one would expect.

 

 project = APT AND parentEpic != APT-16

Will hide the actual Epic, but still show all the stories in it.

 

project = APT AND parent != APT-16

Will only show stories that are not in APT-16, but fails to show any other issue type. 

 

 

project = APT AND "Epic Link" != APT-16

Returns nothing.

 

So how does one show everything that isn't a specific epic or the issues in it?

2 answers

1 accepted

1 vote
Answer accepted
Jack Community Leader Jun 28, 2021

Adding the following JQL snippet to your current filter

AND (issue != apt-16 or “epic link” != apt-16)

Yes, and...to also check for issues with no parent epic:

project = APT AND key != APT-16 AND ("Epic Link" != APT-16 OR "Epic Link" IS EMPTY)

Jack Community Leader Jun 28, 2021

Indeed! I always forget the empty part until I see the results 🙄

And...those fancy quotation marks when copy/pasting solutions into Jira JQL  ;^)

project = APT AND key != APT-16 AND ("Epic Link" != APT-16 OR "Epic Link" IS EMPTY)

That still shows me stories that are children of APT-16 :(

Dave, are you using a company-managed or a team-managed project?

If team-managed, those use Parent instead of "Epic Link", so please substitute that field in the query.

I will leave discussion on that baffling and confusing distinction aside (seriously, wtf?!)  and report that this:

project = APT AND key != APT-16 AND (parent != APT-16 OR parent IS EMPTY)

Does indeed work. Thank you so much!

Like Bill Sheboy likes this

I am glad that helped you. Please consider marking this question as "answered" to help others find solutions faster.  Thanks!

Regarding the field distinction, team-managed projects changed a lot as part of a code re-write, changing the mechanism for linking parents to children...and so causing differences like this.  As I am also just a fellow user/customer, I am equally puzzled by the design choice.  :^)

Like Dave Vedder likes this

Hi @Dave Vedder 

Use the "IN" and "NOT IN" operators. 

project = APT and ("Epic Link" not in (APT-16) or key not in (APT-16))

Regards

Same as above, I can still see the child stories of APT-16 when using that. Iit does hide the actual APT-16  epic, just none of the issues in it.

Hi @Dave Vedder

If that's the case, you probably have them linked in a different way.  Can you show us a picture of how the epic and childs are linked? 

Sure thing. Issues were created by clicking the  + Create Issue  item on the board or by clicking the Add Child Issue button when viewing the Epic directly.  Viewing any issue created this way shows them nested under APT-16. Perhaps I am mistaken but I assumed this meant they were linked to the Epic. 

Thanks for efforts in helping me out, by the way; much appreciated!

 

Issue showing child relationship (this issue is still visible using your suggested filter):

ChildIssueOfAPT16.png

 

Issues made by either clicking the "Create Issue" in APT-16s swim lane...

BoardViewAPT16.png

 

...or by clicking the "Add a child issue" button here.

APT16EpicView.png

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
TAGS
Community showcase
Published in Jira

⏰ Day in the life of a Jira Admin!

Hello Community! We thoroughly enjoyed this just-for-fun conversation in the Jira Admin Group about what it's like to be a Jira Admin. For #JiraJuly, our talented designers created these graphics t...

709 views 2 21
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you