Resolution Date Filter Not Working for Spikes in Kanban Board Column

Question

I am using a Kanban board and the filter query specifies to include unresolved issues OR Done issues if they were completed in the last 2 weeks (filter query below).

The filter query works fine for Stories but not Spikes.  Spikes show in the done column when the status is done regardless of the date (I noticed that Spikes also do no show the slash through the JIRA # like Stories do, so perhaps this is the root of the issue).

Is there anyway to get my board to behave like I want for stories AND spikes?  I don't want completed items that are older than 2 weeks appearing in the board.

Filter =

labels = config AND (resolution = Unresolved OR resolution = Done AND resolutiondate >= -14d) ORDER BY Rank ASC

Petter Gonçalves · Answer

You are welcome!

Please, let us know if your Admin faces any questions regarding the steps in the documentation.

lkingsley · Answer

Gotcha.  I will have to hand this over to our admin, but thanks for your help!

Petter Gonçalves · Answer

Hello Ikingley,

In order to change the resolution field of an issue, I recommend you to perform the procedure mentioned in the article and create the "loop" transition in the issue to perform the bulk update.

If you add the resolution field to the edit screen and simple edit the resolution for the wrong issues, the field will become editable in all the status of your issues. Since the resolution is a required field, it will cause your open issues to wrongly receive a valid value to the resolution field if any user edits it, even before it is transitioned to the status DONE, causing a problem similar to the one you are facing now.