Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Can I apply a filter to the Done column?

Colum McAndrew
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.
August 23, 2021

The lack of a Done column on our Kanban board is causing us a few minor issues. I know you can add the status to a column in the settings, but I don't want all the Done tickets to display. If I do, it just end up growing in size.

What I'd like to do is limit the Done tickets displayed in the column to those that were completed in the last month. Is this possible?

You can't apply a filter to a column, so this seems to indicate the board's filter is the only way of achieving this. To reiterate, I want the Done column to only display tickets marked as Done in the last 30 days

I've tried the following query, but it doesn't return anything.

project = CONTENT AND (status in Done AND statusCategoryChangedDate = startOfDay(-30)) ORDER BY Rank ASC

2 answers

2 accepted

3 votes
Answer accepted
Bill Sheboy
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.
August 23, 2021

Hi @Colum McAndrew 

Is this for a company-managed project with a Kanban board?  If so, you have a couple of options:

  1. change the setting of "Hide completed issues older than" to your desired value
  2. set your "Kanban board sub-filter" to something like resolutiondate is EMPTY OR resolutiondate > -30d

With both of those, reports continue to work normally using your board filter and the display of completed issues is limited.

Best regards,
Bill

Colum McAndrew
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.
August 24, 2021

Hi @Bill Sheboy. Thank you for responding. The "Hide completed issues older than" option seems like the simpliest option, as we do have a company managed project.

Like Bill Sheboy likes this
1 vote
Answer accepted
Trudy Claspill
Community Champion
August 23, 2021

Are you working with a board for a Team Managed project or a Company Managed project?

In a Company Managed project board, you can set an "age" after which issues in the Done column are hidden. This is at the bottom of the Board Settings > General screen. You can set this to 1 week, 2 weeks, 4 weeks, or never hide.

If you are working with a board for a Team Managed project, then the Done column issues are automatically cleared when they have been in the Done column for 14 days. This is not configurable.

Suggest an answer

Log in or Sign up to answer