Query to view uncleared items that are Done from Kanban board

[Ron Beaman]

I have a software project (Team Managed) using a Kanban board. When items are complete we move them to the Done column but periodically we want to clear those items from the board and attach them to a release. Basically, whatever is done at the time we push out a release needs to be added to the release, and then cleared from the board. 

I know I can create a release. I know i can set the fix version in each individual issue to that release. But that's tedious. I know that if i enable the backlog view, i can select them all and drag them to the release. But enabling the backlog view means any new issues get put in the backlog and do not get immediately added to our board so i have backlog turned off. 

If i look at the issues view i can query on the Status of Done, but this does not filter out items that are done and were previously cleared from the board. I haven't been able to determine what field is set when clearing items from the Kanban board. And I'm not sure if there is a good way to add multiple issues to a release by setting the Fix Version to the release without having to edit each individual issue. 

Any help would be appreciated. 

[Mark Segall]

Hi @Ron Beaman - You could try this:

resolved is NOT EMPTY AND fixVersion IS EMPTY

This will show all resolved issues that have no fixVersion applied.

Also, if you're only using releases for bucketing issues, you may want to just update your Kanban board filter to something like this:

project = X AND (resolved IS EMPTY OR resolved < startOfDay(-n)

This will simply drop resolved issues from your board after n days.  No need to tie them to a version unless you actually want to start doing version tracking.

[Ron Beaman]

Thanks for the reply. I do want to associate the items to a release version so that we have good visibility of the items that went into a release. I just haven't figured out a good way to associate multiple items with a release. Seems like there are some options with a company managed setup that aren't available for team managed. 

Thanks for help with the query. I'm still not clear on what is being set when you clear items from the Kanban board. I know the items do not go away and you can still view them from the Issues view, but I haven't found anything that indicates what is happening exactly or what field is being altered to clear them from the board. 

[Mark Segall]

It should be setting the fixVersion field with a specified release.

[Bill Sheboy]

Hi @Ron Beaman 

I wonder...how many active releases do you have in progress at once?

If it is just one in progress, have you considered using an automation rule to move "done" items into the next, unreleased version?

• trigger: issue transitioned to done
• condition: fix version is empty
• action: edit issue to set fix version to the next, unreleased version

That may save you some steps.

Kind regards,
Bill