Azure DevOps Query - show all work items I was involved yesterday

0
votes

I would like to query all work items from Azure DevOps I was involved yesterday.

Now I'm using following query:

enter image description here

So I get all work items I've changed yesterday, so that's ok, but the problem is that "Changed By" returns the last person which have modified the work item. Because of that if someone else did some action on the work item he overwrites the "Changed By" field and results of this query are not as I would expect.

I would like to display all work items that I was involved yesterday - I had changed the state, the assigned to person, made a comment etc. - I would like to query all these items.

Is it possible somehow?

1
azure-devopsazure-boards
Adrian, can you try querying with History field. see if this helps: docs.microsoft.com/en-us/azure/devops/boards/queries/… – Raushan Kuamr Jha
I didn't find any solution unfortunately and right now only idea I have is to create custom extension for Azure DevOps and use WIQL or sth like this to achieve my goal.. – Adrian Bystrek
@AdrianBystrek, Is there anything wrong with my answer? Does it not work for you? If yes, please tell me where is the problem? – Leo Liu-MSFT
You solution gives me all work items I ever changed while I want to get only work items that were changed by me at the specific date (yesterday). – Adrian Bystrek
@AdrianBystrek, Sorry, I posted the error image, I have updated it, would you please check if it help you now? – Leo Liu-MSFT

1 Answers

0
votes

Azure DevOps Query - show all work items I was involved yesterday

To resolve this issue, you could use the Operator Was Ever instead of =:

enter image description here

This will return the work items which was ever changed by someone.

Hope this helps.