Forums

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

Create a Filter that excludes a single epic and its issues

Dave Vedder June 28, 2021

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 Brickey
Community Champion
June 28, 2021

Adding the following JQL snippet to your current filter

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

Bill Sheboy
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
June 28, 2021

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 Brickey
Community Champion
June 28, 2021

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

Bill Sheboy
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
June 28, 2021

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

Dave Vedder June 29, 2021
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 :(

Bill Sheboy
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
June 29, 2021

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.

Dave Vedder June 29, 2021

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
Bill Sheboy
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
June 29, 2021

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
0 votes
Fabian Lim
Community Champion
June 28, 2021

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

Dave Vedder June 29, 2021

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.

Fabian Lim
Community Champion
June 29, 2021

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? 

Dave Vedder June 29, 2021

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
AUG Leaders

Atlassian Community Events