Can I apply a filter to the Done column?

Question

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

Bill Sheboy · Accepted Answer

Hi @Colum McAndrew

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

* change the setting of "Hide completed issues older than" to your desired value
* 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

Trudy P Claspill · Accepted Answer

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.