How to clear old items out of the "Done" column

[Ken Uehling]

I currently have a software project kanban board that shows issues that were created in two other projects. As you can probably imagine, it takes quite a while to load and expand the swimlanes when there are over 800 issues on this new board that I created. 

With that in mind, what would be the best way to filter out any completed issues that are older than 14 days? 

I've looked at two options:

1) AND (NOT (Status WAS IN(done,cancelled) before -30d AND status in (done,cancelled))

2) resolution = null or (resolution != null and resolutiondate < X )

But none of those two options work when I put it in the Kanban board sub-filter. For the first option, I changed "Done" and "Cancelled" to "Approved" and "Rejected" which are part of the board columns / workflow but it did not filter out the older issues. 

I've tried the 2nd one but it did not work - I'm assuming because I do not have a resolution field in my tickets? 

[Petter Gonçalves · Accepted solution]

Hello Ken,

Thank you for raising this question.

The queries you provided seems a little bit confusing for me. Can you please try to add the following parameter and let me know if it works for you?

and resolutiondate >= -30d

It worked properly for me, so it should work for your issues too if you've properly configured the resolution field.

[Petter Gonçalves]

Hello Ken,

Just saw right now that you mentioned you don't have the resolution field in your issues.

In fact, you will need a date field to calculate how many days an issue is closed.

If you have not performed any changes on the issues after the closure, you can use the updated field to perform the query:

and updated >= -30d

Please, let me know if it works for you.

[Ken Uehling]

Thank you, Petterson. It worked!

[Petter Gonçalves]

You are welcome, Ken!

Have a nice day.