Forum Discussion
Detect task location on Azure DevOps sprint board
Hi all, Our company uses Azure DevOps Server 2022 with all its features. We have a project with a Scrum template for task management. Under this project, we use both task boards (main and sprint boards). When defining a query, I can use the "Board Column" field to filter the result based on where the work item is located on the main board. Now I want to use a similar technique to find out where the task is located on the sprint board, and I can't find the field that contains the info. It is even acceptable to find the task column using azure-cli if there is a suggestion.
1 Reply
May try below workarounds:
1. Use Tags or Custom Fields
- Add a tag or custom field to indicate the sprint column manually.
- Update it during standups or task movement.
- Not ideal, but it gives you something to query.
2. Azure DevOps REST API
You can use the Azure DevOps REST API to pull board data, but it’s not straightforward:
- You’ll need to query the team settings and board configuration.
- Then match work item IDs to their column positions.
- This requires scripting and isn’t exposed in the UI or standard queries.
3. Azure CLI (az devops)
Unfortunately, the Azure CLI doesn’t currently expose sprint board column data either. You can list work items, iterations, and states, but not their visual column placement on the sprint board.
