How can I query customized board column change date in TFS 2017

1
votes

I know you can query by state change date instead of column change date if you are using the default columns that match the state. But our TFS board columns are custom. I can see the board column changes in the work item history, so they are clearly stored somewhere. I'm happy with help on a query or if there is some way to do it through the query tool that I haven't figured out.

Thanks.

1
tfs
Are you saying that you want to query based on the date that a work item moved from one column to another? – Daniel Mann
Specifically I'm looking for the list of work items that moved into a column within a date range. – Charles Foushee

1 Answers

1
votes

You can only list work items with Kanban query fields, but can't get column change date.

You need to use TFS api to get work items revisions, and check whether System.BoardColumn field is changed in any revision.