Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

Birt report on Work item and change set link

Questions
Tags
Users
Badges
Vivek Pandey
(43●2●17●38) 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 ?

0 votes

3 answers
6,904 views
0 votes

3 answers

Permanent link
Rafik Jaouani
JAZZ DEVELOPER (5.0k●1●6) 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?

0 votes

Comments
Vivek Pandey
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
JAZZ DEVELOPER (5.0k●1●6) Jan 31 '13, 10:48 a.m.

Vivek,

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

0 votes

Comments
David MICHEL
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

David

Permanent link
Rafik Jaouani
JAZZ DEVELOPER (5.0k●1●6) Apr 06 '14, 6:10 p.m.
In your RTC client install (Eclipse), look for a folder whose name starts with: com.ibm.team.examples.reports.common.
Inside that folder you will find the report under:live\Story Child Work Items.rptdesign

0 votes

Your answer

Register or log in 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.

Ask a question
Guidelines
FAQ
Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 12,020
× 112

Question asked: Jan 30 '13, 10:40 a.m.

Question was seen: 6,904 times

Last updated: Apr 06 '14, 6:10 p.m.

Related questions
Confirmation Cancel Confirm