Finding all Work Items that **were** in my name (any state)
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
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. |
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
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.