How to get workItem history from RTC?
One answer
Once you add RTC Workitems schema (https://[host]:[port]/ccm/rpt/repository/workitem?metadata=schema), use the Query workitem/workItem/itemHistory and you can report on WI history. You can refer %rpe_home%\templates\RTC\RTC_WorkItems.dta, but it does not print history. Please modify it by adding another query.
Comments
Hi Subramanya,
Thank you so much for your help. I got the current status of the defect from your post but how do i get to the initial status of the defect from itemHistory. I mean which field i query on for that. Once again, Thanks for your help.
Hi Atul, The itemHistory will have all the same fields as workItem. If you use workitem/workItem/state/name, it gives the current state and workitem/workItem/itemHistory/state/name gives all previous states (including current state).
