AngryHacker
AngryHacker

Reputation: 61596

How to identify Azure DevOps workitems that were assigned to me in the past 4 days?

There are lots of similar questions from a long time ago, but I don't see an answer.

I have the following setup, which does return all work items that were assigned to me and where Changed Date was changed in the last 4 days. enter image description here

The problem is that if someone goes into the ticket and changes something, the Changed Date is updated and the item ends up back on my list.

So how do I limit the results to include work items that were assigned to me within the last 4 days?

Upvotes: 3

Views: 5243

Answers (1)

Jane Ma-MSFT
Jane Ma-MSFT

Reputation: 5182

There isn't a field that contains the data about Chaged Date of Assigned to, so you can't query work items assigned to you recently.

In addition to the workaround in the link you provided, if you are using an inherited process, you can also use custom fields as a workaround.

Here are the detailed steps:

  1. Go to Organization Settings -> Boards/Process. Select your inherited process. Select a work item type that you want to query. Click on "New field" and fill in the form. The Type of this field should be "Date" .Then, click "Add field".

    Create a field

  2. Select "Rules" tab. Click "New rule" with following configuration:

    Conditions: When A change was made to the value of ... | Assigned To

    Actions: Then Use the current time to set the value of .. | Select the field created in #1.

    Create a rule

After that you can query workitems that were assigned to you in the past 4 days using the new field.

Upvotes: 1

Related Questions