CODEWITHSUNDEEP
azure-devops
tokyo0709
tokyo0709

Reputation: 1997

Queries with calculated fields and sorting

We have started using queries in VSTS to find the projects with the highest value to facilitate a better planning structure and that works great but we also would like to measure that against a cost field. Ideally we would be calculating an ROI field that measures our value against cost and then sorts by ROI.

Is there no way to work with calculated fields in VSTS queries? We haven't been able to find anything so far. Any other workarounds?

Upvotes: 3

Views: 3970

Answers (1)

starian chen-MSFT
starian chen-MSFT

Reputation: 33708

It is not supported.

The workaround is that you can run a query with WIQL through WIQL REST API.

You can update the value in WIQL per to the stored query. (Get WIQL through Queries REST API)

Upvotes: 4

Related Questions