Display only To Do or Backlog Epics (and ALL Done) Tasks on Kansan Board

[Joe Coppola]

Is there a way to display all active Epics as Swimlanes, with all done/completed tasks on a Kanban board?

When using this filter

"issuetype = Epic AND status in (Backlog, "In Progress")" you do not get the completed tasks. Basically I want to hide the DONE epics but display the done tasks.

[John Funk]

Hi Joe,

Maybe try: Project = ABC and (issuetype = Epic and status in (Backlog, "In Progress")) or (issuetype != Epic and statuscategory = Done)

[Joe Coppola]

Thanks, but that still brings in Done epics.

[John Funk]

It shouldn't - I have tested it on my instance. Did you type it EXACTLY as I have it? 

[Joe Coppola]

Yea it shows all Epics regardless of its status.  Basically the EPICs are showing the Kansan board because the epic has DONE tasks.  

The interesting thing is that in the query result it does only show the EPICS that are open but it shows completed tasks for DONE epics.  And I think the Kansan board displays these EPICs because of the tasks.

[John Funk]

Can you share a screenshot of the query in the board settings?

[Joe Coppola]

Sure... FYI it strips the extra parens after saving it

[John Funk]

That's the problem then. 

Is this in the Advanced search where you save the filter? 

[Joe Coppola]

Im not sure wha you mean by Advanced Search?  The parens get stripped no matter where you put the filter... even in the filter criteria using JQL.

Is there somewhere else Advanced Search is?

[John Funk]

It should not strip the parens in the area where you are saving the filter. That's a totally different query without the parens. 

What are the exact steps you are doing after you put in the parens and execute the query? 

[Joe Coppola]

I basically goto the Filters area.  Change to JQL copy and paste the query. Modify it to be my project and click search and then save.

When you go back to the query after its saved it strips the parens.  However the results are exactly the same regardless of the parens.

[Joe Coppola]

Actually I did finally get it to save with the parens by using a manually saved filter.  But results are still the same.

[John Funk]

Ah, that might be the problem. Jira doesn't like it when you paste in there sometimes. Try typing it from scratch and see if it will let you execute and save it. 

[Joe Coppola]

See above... I got it to save but same results

[Joe Coppola]

Are you testing this query in a Kanban board? Make sure you dont have Hide Completed Issues Older than turned on.

[John Funk]

And you are saying that with that query above on the board, you still see completed Epics???

[Joe Coppola]

Yes it shows completed EPICS in the Kanban board.  But NOT in the in the filter results.  However it shoes Tasks in the query results so I think the Kanban board displays the epic because there is a task associated with the EPIC

Meaning I think Kanban board ignores the Epic results and displays EPICS regardless of the query itself

[John Funk]

Can you show another screenshot with an example?