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

Question

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!

Answer 1

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

To view more details, you can see:

• Query history and discussion fields
• Operators and macros supported for each data type

[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.

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.

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