azure-devopstfs-workitem

Azure DevOps Query all past iterations


I am new to Azure DevOps queries and I am trying to build a simple query that would return all Tasks that have changed state today and belong to past iterations. In other words, how do I query all iterations before @CurrentIteration?

Here is what I have done so far:

Work Item Type = Task
State changed = @Today

So I need something like

Iteration Path < @CurrentIteration

But the < operation is not allowed on Iteration Path, and I can’t use @CurrentIteration with Iteration ID.

Thanks for taking the time to answer.


Solution

  • You can not use the larger than/smaller than operator on Iterations, but you can select the parent Iteration and then use the "Under" operator, that will take all the items in the parent iteration and below. If you want to exclude the backlog itself you can also add a "and not in backlogIteration".