BIRT Reporting - SCM_Snapshot Change_set table
I am evaluating the reporting capabilities of RTC v3.0.1 and I am stuck in the following scenario:
I would like to create a report that contains (among other things) a per-user list of code deliveries (change sets) to a certain stream.
I have run the jobs to populate the datawarehouse and I have also selected my stream in the "Administer SCM Snapshot" page.
I have created a BIRT report with an SCM_Snapshot datasource and I am able to retrieve the list of available streams on the "CHANGE" table without problems.
However, when I try to access the "CHANGE_SET" table, I'm getting always empty results.
Are there any mandatory parameters I need to specify in order to get the list of Change sets? Is my problem related with the fact that I am using a Derby DB?
thanks in advance for your help,
Emilio
I would like to create a report that contains (among other things) a per-user list of code deliveries (change sets) to a certain stream.
I have run the jobs to populate the datawarehouse and I have also selected my stream in the "Administer SCM Snapshot" page.
I have created a BIRT report with an SCM_Snapshot datasource and I am able to retrieve the list of available streams on the "CHANGE" table without problems.
However, when I try to access the "CHANGE_SET" table, I'm getting always empty results.
Are there any mandatory parameters I need to specify in order to get the list of Change sets? Is my problem related with the fact that I am using a Derby DB?
thanks in advance for your help,
Emilio
One answer
The change set is live table that requires the change set item id. This table is mainly used for tracing file changes from work items. So you always need to start with work items, find the change set links which will give you the change set item ids. Using those item ids, you can get to the list of changed files.