JQL query to Filter issues linked to epics in Implementation status

[Sari]

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!

[Bill Sheboy · Accepted solution]

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

[Sari]

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!

[Bill Sheboy]

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