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

JQL query to Filter issues linked to epics in Implementation status

Hello. 

I have a kanban board in Jira where there are only EPICs. 

Each EPIC has several tasks linked to It, belonging to different projects (Project X,Y,Z). 

I want to create to select all the tasks belonging to Project X and in the status "implementation".

 

EPIC Board ---> issues in project X ---> status = implementation

 

I tried this query, but It does not work: 

 

project = EPIC board AND project = "X" AND status = Implementation

 

Could you please give me some suggestions?

 

Thanks!

 

 

 

1 answer

1 accepted

0 votes
Answer accepted

Hi @Sari 

Do the issues in "project X" only have links to epics in your "epic project"?  If so, you could find these with:

project = X AND status = "Implementation" AND "Epic Link" IS NOT EMPTY

If instead there are links to other epics, you would narrow your search by looking for the specific epics:

project = X AND status = "Implementation" AND "Epic Link" IN (epicKey-123, epicKey-456)

 

Kind regards,
Bill

Hi @Bill Sheboy , thank you so much, this filter works perfectly.

I just have another small question related.

This filter works when I go to "Filter" and then in "advanced search issue", but I wanted to add this filter in my Kanban board as a "quick filter", and I used exactly the same query, but then It doesn't display any issue. 

Why does It happen?

Thanks!

Schermata 2022-01-14 alle 09.32.49.png

Hi, Sari!

The thing about quick filters (and Kanban board sub-filters) is they add onto the existing board filter; they do not replace it.  So the issues may have already been excluded by the board filter.

One possible work-around is to make your board filter less specific, and then use the quick filters to limit what is shown.

Please note: if your team is using the current board, you may not want to change the filter.  Instead, consider if you should create an additional Kanban board just for this type of reporting/analysis.

Kind regards,
Bill

Like Sari likes this

Suggest an answer

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

Do you use Jira Cloud with Microsoft Teams?

Hi, Jira users! Do you use Jira alongside Microsoft Teams? We want to hear how you’ve used the power of Jira Cloud and Microsoft Teams (via the Jira Cloud for Microsoft Teams app) to achieve a team...

163 views 1 5
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