I have to generate a report against RTC 2.0.0.2 listing stories, approvers, and history; Where in Insight is this data available?
I have to generate a report against RTC 2.0.0.2 listing stories, approvers, and history; Where in Insight is the approver and history data available?
|
One answer
The out of the box RTC 2.0.0.2 ETL will *not* load the relationship between work item and approver. So if you need to generate that report, you have to customize ETL.
Stories should be stored into RIODS.Request table. You can use Request_Type to filter all stories. History data is available in RIODS.REQUEST_CHANGE_HISTORY. Request_ID in RIODS.REQUEST_CHANGE_HISTORY is the foreign key of RIODS.Request. |
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.