agilescrumazure-devopskanban

VSTS - BoardColumn does not work in Queries


In VSTS Online, using BoardColumn as a Query Criteria, or using it as a Column in Query Results, does not work.

For instance, we have custom columns, beginning with Committed, and progressing through additional states. It seems that the system only allows us to query using out-of-the-box column names, that match State values.

If I query for BoardColumn = Committed, the query returns Work Items that are in the Committed Column, or any of the subsequent columns, and the displayed value for BoardColumn in the query results simply says "Committed", because that is the State value on those Work Items.

Additionally, using one of the custom columns, such as "In QA", as a criteria value for Board Column, returns zero results, even though there are Work Items in that column.

This does not make sense. Why does the query functionality not actually look at the BoardColumn value when querying? Why does the query result display State instead of BoardColumn?


Solution

  • A few weeks ago I ran into an issue similar to this. We had our team split into two, and one of the new teams was using the Kanban board. For the split we used the information on Visualstudio.com

    We noticed that, whilst the items were positioned in the correct board column, any queries would give the old state (i.e. Committed).

    A hint to the problem was found on visualstudio.uservoice.com where they were discussing which teams owns the item. Eventually I realized that, whilst our two new teams both had their own backlog iteration, so did the old 'root' team. Changing the Backlog Iteration path of the old team to some subiteration solved the problem for us. It seems the old team was still considered the owner.

    The question seems to be: is your Work Item also visible on another Board? Then this might be the solution.

    This is all TFS 2017 on-premises.