Kanban board- Proper query for all issues marked as done for less than a week

Question

I am trying to edit my Kanban board to where all issues marked as "Done" will stay visible in the Kanban board for one week, but I am struggling in finding the proper query for this. This is what I hate so far:

project = III AND resolution in (Unresolved) OR project = III AND resolution != EMPTY OR Project = III AND resolution != null AND  resolutiondate < 7d ORDER BY Rank ASC

Any input is greatly appreciated.

shetty · Answer

project = III AND resolution in (Unresolved,Done) AND resolution not in (EMPTY,null) AND  resolutiondate < 7d ORDER BY Rank ASC

I have included that query and simplified it as well

Former user · Answer

Thank you, where exactly should I put this in the query?

shetty · Answer

You need to include project = III AND resolution=done if you looking by resolution

then it will show you the issues that are having resolution as done