Kanban Board - Subfilter - display tickets updated to "Done" in the past 2 weeks

Question

Hi Everyone.. i need to configure "Done" column to display only tickets updated to "Done" in the last 2 weeks on th Kanban board. I need a query to place in the subfilter that will do this..
This is what i have come up with >
resolutiondate is EMPTY OR status changed to Done AFTER -14d

The problem is that is a resoltion date is set and we pass the resolution date deadline and its not marked as DONE, it disappears from the Kanban board.. Need a solution for this pls/ty

Ranjit Paranjothy · Answer

Hi @Tzoe_Keat_Chiam ,

I tried that and it doesn't work as intended. There is one ticket which is in-progress and the due date has passed 14 days and it disappears from the Kanban board after i apply your suggested subfilter.

Can you suggest a structured query where >
resolution date for open / in-progress / QA status doesn't matter but when moved to Done status, show only tickets marked Done in the past 14 days.

Tzoe_Keat_Chiam · Answer

Hi @Ranjit Paranjothy,

Then try this:

(status = done and resolutiondate >=-14d or resolutiondate is empty).

Hope this is better!

Ranjit Paranjothy · Answer

Thank you @Tzoe_Keat_Chiam for your quick response. im not sure if this is the one that will work for my scenario. when i apply this "(resolutiondate >=-14d or resolutiondate is empty)"  , some tickets are removed from the open and in-progress columns as well..

My scenario is that the Done column should show tickets moved to the Done status in the past two weeks and all other tickets should remain as they are .

If the ticket has a resolution date that has passed 14 days and it is in the open/in-progress status then it should still be visible on the Kanban Board.