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.2k12252) | answered Nov 15 '16, 8:41 a.m.
Hi Deepak,

Please follow the link below

https://jazz.net/help-dev/clm/index.jsp?topic=%2Fcom.ibm.team.workitem.doc%2Ftopics%2Ft_queries_creating.html

Regards,
Arun.


permanent link
Donald Nong (14.4k314) | 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:
https://clm:9443/ccm/rpt/repository/workitem?fields=workitem/workItem[owner/userId!="marco"]/(id|summary|owner/(userId|name)|itemHistory[owner/userId="marco"]/state/name)
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.