It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Follow this question
Question details

×42,787
×11,924
×1,235

question asked: Jun 27 '12, 4:01 p.m.
question was seen: 4,771 times
last updated: Jun 27 '12, 11:03 p.m.

Related questions

FAQ - How this Forum works

I have to generate a report against RTC 2.0.0.2 listing stories, approvers, and history; Where in Insight is this data available?

0
Dave Decker (33●15●16) | asked Jun 27 '12, 4:01 p.m.
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

Most liked answers ↑|Newest answers|Oldest answers

0
permanent link
Hopeshared Lee (11●2●1) | answered Jun 27 '12, 11:03 p.m.
JAZZ DEVELOPER
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

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.