CODEWITHSUNDEEP
azure-devopsworkitem
Snooks
Snooks

Reputation: 131

Is it possible to query when a specific field changed in Azure DevOps?

I have a DateTime field (MyDTField) in my Azure DevOps instance (I am an admin on it, so I can change its schema if necessary). I would like to write a query that returns any items where the above field (MyDTField) changed in the last 7 days. Is this possible to do?

For e.g. the built in "Changed Date" field allows us to write a similar query, but that returns work times where any field value changed. I want to get items where a specific field changed within a specified time period.

Thanks!

Upvotes: 1

Views: 9179

Answers (1)

Bright Ran-MSFT
Bright Ran-MSFT

Reputation: 13479

You can try to set up a query like as below to see if it can work as expected.

enter image description here

To view more details, you can see:

[UPDATE]

As a workaround, you can try like as below on each of the work item types that have the MyDTField field:

  1. Add another custom Date/Time field, for example "MyDTField Latest change Date" field. enter image description here

  2. Add a work item rule like this. With this rule, once the MyDTField field changed, the value of the MyDTField Latest change Date field will be automatically changed to the current date/time. enter image description here

  3. Set up the query like as this. With this query, you will get the list of work items as your expectation. enter image description here

Upvotes: 2

Related Questions