It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Follow this question
Question details

×42,786

question asked: Jan 05 '12, 12:56 a.m.
question was seen: 3,560 times
last updated: Jan 05 '12, 12:56 a.m.

Related questions

FAQ - How this Forum works

I need advice on creating a report to compare snapshots?

0
Steve Chapman (1●3●3) | asked Jan 05 '12, 12:56 a.m.
I have RTC 3.0.1.1.

I need to create a report that will show the contents of an SCM snapshot in a similar manner to the snapshot compare feature in the RTC web ui. I would like to show all changesets that are contained in the each component in the snapshot that are not in an earlier snapshot. This will be used to report the changes being delivered in a particular build/release that is to be deployed in production.

I have installed the BIRT plugin into the RTC Eclipse Client and can create a Jazz datasource and have browsed the available snapshots and associated tables. I thought the LIVE_SNAPSHOT would be appropriate but cant find any tables with data related to changesets (or at least I dont understand the schema to be able to create an appropriate query).

Can someone offer some direction?

Thanks
Steve

One answer

Most liked answers ↑|Newest answers|Oldest answers

0
permanent link
Kim Soederhamn (1.5k●2●42●47) | answered Jan 06 '12, 8:22 p.m.
I have RTC 3.0.1.1.

I need to create a report that will show the contents of an SCM snapshot in a similar manner to the snapshot compare feature in the RTC web ui. I would like to show all changesets that are contained in the each component in the snapshot that are not in an earlier snapshot. This will be used to report the changes being delivered in a particular build/release that is to be deployed in production.

I have installed the BIRT plugin into the RTC Eclipse Client and can create a Jazz datasource and have browsed the available snapshots and associated tables. I thought the LIVE_SNAPSHOT would be appropriate but cant find any tables with data related to changesets (or at least I dont understand the schema to be able to create an appropriate query).

Can someone offer some direction?

Look at the CHANGE table of the SCM_SNAPSHOT - I think you can find what you need there.

Thanks
Steve

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.