How to eliminate tickets with a certain Epic?

[Phillip Renault]

I am working on changes for a customers Jira project where they have asked to show only tickets related to the items they are working daily.  For this they requested their own Kanban board within the established project.

To filter this board, I created an Epic that they can attach their tickets to.  This works as desired.  They have a requirement that these tickets be filtered out from the main project board when desired.  The main board filter is currently configured with the following filter:

• project = "cool project" AND issuetype = Story 

I have created the following quick filter on the main board to show only tickets with the epic from the other board.

• epic link = "Cool Epic-1234"     This quick filter works as desired.

My problem comes when I try to create a quick filter that will still display all tickets on the main board except for those with the "Cool Epic-1234" link.  I started with epic link != "Cool Epic-1234" and have tried many variations to filter out only that epic.  Every way I think of eliminates all stories.  I have tried some of the following variations in issue navigator and get no results.

• epic link != "Cool Epic-1234 AND project = "cool project" AND (issuetype = story)
  • This seems to work until I add the last argument and lose all results
• project = "cool project" AND issuetype = story AND (epic link != "Cool Epic-1234
• project = "cool project" AND issuetype = Story AND issuefunction not in epicsOf("'epic link' = Cool Epic-1234")
  • This one returns tickets I would expect but doesn't remove the tickets with the cool epic link

Any help is greatly appreciated.  I feel like this shouldn't be difficult and I'm missing one small detail or there is something off in the project I haven't found yet.  

[Varsha Joshi]

Hi @Phillip Renault 

Welcome to the community!

Could you try using Not In and In instead of "=" or "!=" ? In my experience that way of creating JQL always got me the exact search results.

Hope that works.

Thanks

Varsha

[Phillip Renault]

Tried:

• project in ("Cool Project") AND issuetype in (Story) and "Epic Link" not in (Cool Epic-1234) 
  • This returns results issues in issue navigator but not as a main filter.  Additionally it eliminates newer tickets I know should be visible on the board.
  • as a quick filter on the main board, "Epic Link" not in (Cool Epic-1234) eliminates all results when applied on top of the primary filter (project = "cool project" AND issuetype = Story)

[Varsha Joshi]

Do you mean saved as a filter or when used as a board filter?

Also I would try parent link instead of epic link.

[Phillip Renault]

I am trying both at this point.  I either need to rework the main filter to eliminate the tickets with the specific epic or a quick filter that can eliminate the tickets with the specific epic link.

[Phillip Renault]

So parent seems to only work with initiative.  No matter what I did, if I called out the epic directly, I got no or inaccurate results.  I don't think I understand issuefunction well enough and that was working here are the filters I got to work, giving my customer options

Whole board filter: project = "cool project" AND issuetype in (Story) AND issuekey not in childissuesOF("Cool Epic-1234")

Quick Filter: issuekey not in childissuesOF("Cool Epic-1234")

Are there any good resources to learn more about issue function?

[Aaron Williams]

Hey @Phillip Renault ,

Have you tried using Parent != "Cool Epic-1234" instead of "epic link"? 

project = "cool project" AND issuetype = Story AND Parent != "Cool Epic-1234"

Something like that. 

Let me know how it that works 

Thanks,

Aaron.