Training
Learning path
Implement finance and operations apps - Training
Plan and design your project methodology to successfully implement finance and operations apps with FastTrack services, data management and more.
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Azure DevOps Services | Azure DevOps Server 2022 - Azure DevOps Server 2019
You can create queries based on how one field's value compares to another using the comparison field operators. This query is useful to filter work items based on:
You can use the comparison field operators—=[Field], <>[Field], >[Field], <[Field], >=[Field], <=[Field]
—with the following field data types. The data type you select for the Field and the Value must match.
=[Field], <>[Field]
Note
Some combinations of data type and comparison field operator might not make sense to use, such as Title >=[Field]
or Assigned To <=[Field]
.
Filter for
Include these query clauses
Work items closed by someone other than the person who created the work item
Created By <>[Field] Closed By State = Closed
Tasks whose Original Estimate is less than Completed Work
Original Estimate <=[Field] Completed Work
Closed tasks completed before their target date
Target Date <=[Field] Closed Date State = Closed
The following table provides an index to those fields that support field comparison queries.
Note
Not all fields listed are supported for all projects or work item types. However, you can customize a process or work item type by adding custom fields which you can use for the purposes of queries and field comparisons. For more information, see Add a custom field to a work item type (Inheritance process) or Add or modify a field (Online XML process).
To programmatically interact with queries, see one of these REST API resources:
Training
Learning path
Implement finance and operations apps - Training
Plan and design your project methodology to successfully implement finance and operations apps with FastTrack services, data management and more.