Using SubQuery on Kanban Board to Exclude Work Items where FixVersion is Empty

Question

I am trying to use the subQuery filter on a kanban board to filter out all accepted work for only one column that is already released. Has anyone done this before or can someone lead me in the right direction?

JD Lobue · Answer

I don't think you are understanding what I'm asking, and I believe the answer is that subqueries do not handle this situation.

I want the board to still have it's own filter query and just the accepted column being further filtered differently. Doesn't sound like Atlassian can handle this. Thanks!

Nic Brough -Adaptavist- · Answer

Yes, that's why I said "kind of destroys the point of having a board".

I don't think the sub-query is the place to do what you are asking for here, I think you're going to need to do it with the board query, changing it to:  Show me (all the issues in all the columns *except* the accepted column) OR (issues that are in the accepted column AND have a fixversion)

Assuming the base of the board is just "project xyz", and your accepted column is mapped to the status "accepted" and no other status, then your board query should be

Project = XYZ and ( (status != accepted) OR (status = accepted AND fixversion is empty) )

JD Lobue · Answer

That would not show me all the other items on the board. What I want is all the items in our other columns (To Do, In Progress, etc.) and only the accepted column to filter out fixVersion. What you suggest will not do that.