CODEWITHSUNDEEP
tfs
user2543622
user2543622

Reputation: 6756

Find WorkItems that were assigned and finished in the last 30 days

I would like to see a list of workitems assigned to a particular person. I would also like get information about when those workitems were completed. Is there any column like assigned_date and finished_date that i could use?

I saw [Status]='AssignedTo' but didnt find anything that says when it was assigned and when it was finished

This link provides some info that I am looking for but not everything.

Upvotes: 1

Views: 134

Answers (1)

PatrickLu-MSFT
PatrickLu-MSFT

Reputation: 51083

You could use the operator “Was Ever” that searches for a value in a field in the history of Work Items. Such a query will return all Work Items you were/someone assigned to, even if now they are assigned to a different person. enter image description here

However, there is not any assigned_date and finished_date you could use. Several date and identity fields are set based on workflow states or transitions. You could find all Date and Iteration Path fields here.

You have to use Revisions - List Rest API to return the list of fully hydrated work item revisions and fetch the work item assigned and finished time. Finally check if they are in the last 30 days.

GET https://dev.azure.com/{organization}/{project}/_apis/wit/workItems/{id}/revisions?api-version=6.1-preview.3

Upvotes: 2

Related Questions