CODEWITHSUNDEEP
tfs
Ilia G
Ilia G

Reputation: 10211

How to query for my recent work items

The closest I was able to come up with is this:

(State = Closed or Assigned To != [me]) and Changed By Was Ever [me] and State Changed Date >= @Today - 7

That produces number of false positives on items that still being worked in QA or being touched by people handling merges. All I need is the items I touched in the last 7 days. This would be a trivial SQL to write, but TFS query UI doesn't seem to be flexible enough for this...

Upvotes: 3

Views: 2032

Answers (2)

Baig
Baig

Reputation: 1519

Try this to get the work items in a sprint that were assigned to you ever and have current state closed or resolved. Please note that the state clauses are grouped.

enter image description here

Upvotes: 0

Jeff Maxwell
Jeff Maxwell

Reputation: 41

You can use the Cube to find out who has changed a work item in the past.

If you use the "Work Item Changeset" perspective you can create a pivot table in Excel by Work Item Title and Changed By and filter on the Changed Date for the last 7 days.

Upvotes: 1

Related Questions