It's all about the answers!

Ask a question

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


Deepak Vasudevan (111) | 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.2k13277) | 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.5k514) | 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.


Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.