It's all about the answers!

Ask a question

Finding all Work Items that **were** in my name (any state)

Deepak Vasudevan (11) | asked Nov 15 '16, 8:36 a.m.
 Can some one help me to form a query in RTC to enlist all work items that **were** in name which I would have worked on and then closed and assigned to a different user.

2 answers

permanent link
Arun K Sriramaiah (3.2k12571) | answered Nov 15 '16, 8:41 a.m.
Hi Deepak,

Please follow the link below


permanent link
Donald Nong (14.5k314) | answered Nov 15 '16, 7:00 p.m.
I can't think of a way that a work item query can give you such result, as it does not give you access to history. On the other hand, the reportable REST API can do this with a bit of post-processing. You can just use this REST request:
This request shows you all the work items that are currently _not_ owned by user "marco", and also shows a previous state when "marco" was an owner. So in the result, the work items that do contain the "workitem/workItem/itemHistory/state" attribute are what we want. Simply replace the user ID "marco" with your actual one and you should get what you want.

Your answer

Register or to post your answer.