It's all about the answers!

Ask a question

why the change set table in RTC is enpty?through birt

Bin Qi (2123) | asked Oct 12 '12, 2:59 a.m.
customer want to get some report through birt. we can get work item data from rtc but the changeset table are empty? Do some one meet the same problem? what's wrong with it? The table of change set has no data,or the birt has something wrong? Thanks a lot~~

5 answers

permanent link
Bin Qi (2123) | answered Oct 15 '12, 7:42 a.m.
Thank you Lauren.
I found the reason.
I must give the value of parameter of CS_ITEM_ID

Lauren Hayward Schaefer commented Oct 15 '12, 7:46 a.m.

I'm glad you got it working!

permanent link
James Moody (3.3k24) | answered Oct 18 '12, 9:02 a.m.
 As a followup - glad you've figured this out. The change set "table" actually isn't stored in the data warehouse at all; BIRT accesses this data directly from the operational data store. As such, we designed this data set in such a way that it requires the change set item id (so we don't try to query for all change sets in the system, for example).


permanent link
Lauren Hayward Schaefer (3.3k11427) | answered Oct 12 '12, 6:56 a.m.
Have the data collection jobs been run recently?  You can kick them off manually by authenticating as an admin user, clicking the gear icon in the upper right-hand corner, choosing Manage Reports, and then Run all data warehouse collection jobs.

permanent link
Bin Qi (2123) | answered Oct 12 '12, 9:57 p.m.
I run the data warehouse job again,
all other table ,such link ,work item have record,except the changeset table
but the changeset table is very import for our customer

Lauren Hayward Schaefer commented Oct 15 '12, 6:56 a.m.

I'm not sure why the changeset table is empty.  Perhaps someone else can give you some advice.

permanent link
Leonardo Marzo (24964852) | answered Jul 07 '14, 5:39 p.m.
 Is it possible to get the change sets between two baselines? Given that you need to provide the CS_ITEM_ID, is it possible to get the change sets created between two dates ? 

I´ll appreciate your help. 


Your answer

Register or to post your answer.