It's all about the answers!

Ask a question

Birt report on Work item and change set link

Vivek Pandey (4321538) | asked Jan 30 '13, 10:40 a.m.

I can find the change_set link type in Auditable table of DWH , however, how to get details of those change sets ?

I'm trying to get the report on work-items and related change sets, how can i get it from from RTC or more specifically DWH ?

3 answers

permanent link
Rafik Jaouani (5.0k16) | answered Jan 30 '13, 11:30 a.m.

Vivek, the data warehouse does not have a table named Auditable. I think I will need more information from you:

Version of RTC

Are you writing your report using BIRT, RPE or RRDI?

Vivek Pandey commented Jan 31 '13, 12:02 a.m.

Hi Rafik,

Sorry, I meant to refer to auditablelinks table within LIVE snapshot.

I'm using RTC V3.0.1.

The Report I'm trying to generate is using BIRT.

So, is there any way possible to get the report in BIRT using RTV 3.0.1 on work-item and associated change sets and their further details like no# of files in each change set ?

permanent link
Rafik Jaouani (5.0k16) | answered Jan 31 '13, 10:48 a.m.


Check the out of the box report named Story Child Work Items. I think you can use it as a example for your report.

David MICHEL commented Apr 06 '14, 5:17 p.m.

Hello Rafik,
    Could you tell me where I can find this example?
Thank a lot in advance for your help

Best regards


permanent link
Rafik Jaouani (5.0k16) | answered Apr 06 '14, 6:10 p.m.
In your RTC client install (Eclipse), look for a folder whose name starts with:
Inside that folder you will find the report under:live\Story Child Work Items.rptdesign

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.