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

Does RTC store the history of custom attributes?

Hi,

I'm trying to retrieve data from RTC/Rational Data Warehouse (v6.0.3) using SQL. For most things I've been able to use the Jazz Reporting Service Report Builder to generate the SQL I need.

My problem is that the report builder does not appear to allow custom attributes to be used to filter the results of historical trend reports, which is what I need to do.

My question is; Does RTC store the history of custom attributes?

And if so, does anyone have example SQL of filtering a historical trend report using a custom attribute?

Thanks in advance

0 votes



One answer

Permanent link

 Lewis,


this seems to indicate that it does (this is from 6.0.6.1).


I would suggest to look into that and experiment with the generated SQL. 

Please note that complex item values such as contributors, items and some other types that are not represented by a simple value might not be represented in the data warehouse.

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.

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
× 10,941
× 37

Question asked: Sep 09 '19, 12:01 p.m.

Question was seen: 2,267 times

Last updated: Sep 18 '19, 2:10 a.m.

Confirmation Cancel Confirm