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,299,335
Community Members
 
Community Events
165
Community Groups

Edit Filter Query on Kanban Board to Include Epics

Hi All,

I'm trying to edit the filter query on my Kanban board to only include an epic.  Can someone please help with the syntax?

This is the current syntax:

Project = PCRF and Issuetype in (bug, story)

I want to include "= EpicName ..." and then the name of the epics.

Any help would be greatly appreciated.

Thanks!

1 answer

1 vote
Mikael Sandberg Community Leader May 24, 2022

This JQL should do the trick:

project = PCRF AND "Epic Name" = "<Your epic>" ORDER BY Rank ASC

Or if you want to see all epics in the project, this one will do it:

project = PCRF AND issuetype = Epic ORDER BY Rank ASC

Thanks for getting back to me.  Can I add only 2 epics, for example "Epic Name" = "Campaign Enhancements, Campaign Management".  When I add the 2nd epic name it gives me an error.  

Really Appreciate your help.

Samer

Mikael Sandberg Community Leader May 24, 2022

If you want to add multiple values to Epic name you have use the in operator like this:

"Epic Name" in ("Campaign Enhancements", "Campaign Management")

Thanks Mikael.  One more question.  Here is my query:

project = PCRF AND "Epic Name" IN ("Campaign Enhancements", "Campaign Management") ORDER BY Rank ASC

This lists only the epics on the Kanban Board.  I want the board to list the user stories only from the EPICS listed above.

Thank you.

Mikael Sandberg Community Leader May 24, 2022

Okay, basic JQL doesn't allow you to do nested filters, you would need an app for that, so in order to get the issues linked to the two epics your filter should look something like this:

project = PCRF AND ("Epic Name" IN ("Campaign Enhancements", "Campaign Management") OR parentEpic in (PCRF-<epic number>, PCRF-<epic number>)) ORDER BY Rank ASC

This worked.  Thanks again!

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Jira Software

Upcoming changes to epic fields in company-managed projects

👋 Hi there Jira Community! A few months ago we shared with you plans around renaming epics in your company-managed projects. As part of these changes, we highlighted upcoming changes to epics on...

14,962 views 38 49
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