Epics not appearing on Kanban Board - query states epics should show

Ravi Mistry
Contributor
July 4, 2019

Hi, 

 

I am trying to filter by epics on our kanban board.

 

The query is project = PUBS AND issuetype in ("Bug - FE", Improvement) AND "Epic Link" in (PUBS-7, PUBS-14, PUBS-3, PUBS-4, PUBS-5) ORDER BY Rank ASC 

 

I have put epic link in and when i go on board settings and select base swimlanes on epics it doesn't show. 

 

Am I missing something in the query?

 

I have attached screenshots for reference. 

 

Thanks, 

Ravi

 

Epics_screenshot.pngFilter.pngBoard_with_epics_-_not_showing.png

2 answers

0 votes
neil walcuch July 4, 2019

Unless im misunderstanding and take g a really simplistic view, check the "status" of your epic and that it is "in progress". I have experienced this before where the epic and all children ( bugs, sub-tasks and doctasks) do not appear because the Epic status was inadvertently changed.

Ravi Mistry
Contributor
July 4, 2019

Nope it wasn't that. The query above solved my problem, Thanks !!

Like neil walcuch likes this
0 votes
Andrew
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.
July 4, 2019

Hi @Ravi Mistry ,

Could You please check that JQL return some results in 'search for issues' ?

B.R.

Ravi Mistry
Contributor
July 4, 2019

Hi, 

 

Sure - 

 

attached a screenshot,Results_returned.png

Andrew
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.
July 4, 2019

I reproduce it on my server. I found https://community.atlassian.com/t5/Agile-questions/Epics-do-not-appear-on-my-Kanban-board/qaq-p/767535

Looks like filter should also return 'epic' issue type not only child.

Try add 'or "Epic Name" in ( test, testB)'.

B.R.

Ravi Mistry
Contributor
July 4, 2019

So I would need to name the epic name exactly as epic link? 

 

I've tried with epic name but nothing happening, not sure what format i should do.

Our epic links are:-

Cubitt House - Templates

Hall & Woodhouse Templates

Hippo Inns Templates

Young's Pubs - Templates 

JW Lees - Templates

Andrew
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.
July 4, 2019

Use dquote for epic name:


project = BBBK and "Epic Name" in ("test", "testB" ) or (issuetype in (Story, Epic) and issuekey = BBBK-29) ORDER BY cf[10300] ASC

or just 'is not empty' for all epics:

project = BBBK and "Epic Name" is not EMPTY or (issuetype in (Story, Epic) and issuekey = BBBK-29) ORDER BY cf[10300] ASC

B.R.

Ravi Mistry
Contributor
July 4, 2019

I'm a bit confused - so i did try this and managed to get mine to show on search but the board still is not showing epics.

 

Could we do it by queries?

 

e.g for the 5 epics show these on boards?

My current query is :-project = PUBS AND issuetype in ("Bug - FE", Improvement) AND "Epic Link" in (PUBS-7, PUBS-14, PUBS-3, PUBS-4, PUBS-5) ORDER BY Rank ASC  

 

What would need changing here for epics to appear?

Epic Names are: -

Hippo inns Templates 

Cubitt House - Templates 

JW Lees - Templates

Young's Pubs - Templates 

Hall & Woodhouse Templates

Andrew
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.
July 4, 2019

I suppose 

project = PUBS AND "Epic Name" is not EMPTY or ( issuetype in ("Bug - FE", Improvement) AND "Epic Link" in (PUBS-7, PUBS-14, PUBS-3, PUBS-4, PUBS-5)) ORDER BY Rank ASC

or

project = PUBS AND "Epic Name" in ("Hippo inns Templates", "Cubitt House - Templates", "JW Lees - Templates", "Young's Pubs - Templates", "Hall & Woodhouse Templates") or ( issuetype in ("Bug - FE", Improvement) AND "Epic Link" in (PUBS-7, PUBS-14, PUBS-3, PUBS-4, PUBS-5)) ORDER BY Rank ASC

B.R.

Ravi Mistry
Contributor
July 4, 2019

Perfect! i think this has done the trick, only question is what would i need to do to show it that anything without epics is not listed.

On search it shows epics and everything without epic.

Suggest an answer

Log in or Sign up to answer