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

What custom RTC fields are available in the data warehouse?

Questions
Tags
Users
Badges
Jackie Albert
(1.6k●1●49●47) Feb 22 '16, 9:36 a.m.
There are many custom field types I can add to a Work Item as I extend RTC, such as Short String, Medium String, Enumeration, etc.   However, it's not clear how all of these field types are represented (or if they are) in the data warehouse.

I know that some field types, such as the "List" types, are not brought to the data warehouse by the DCC jobs.  I'm not sure about the "HTML" fields.  Is there a full list available of which field types are reportable and which to avoid if you'd like to use them for reporting?

1 vote

3 answers
7,793 views
1 vote

3 answers

Permanent link
Kot T.
JAZZ DEVELOPER (1.5k●1●13●19) Feb 22 '16, 3:39 p.m.
The following jazz.net thread may not give an absolute answer, but can be a good reference:
https://jazz.net/forum/questions/145323/locating-specific-data-warehouse-tables-that-contain-custom-fields-and-their-corresponding-data

Custom HTML attributes are available in the data warehouse.

1 vote

Comments
Jackie Albert
Feb 22 '16, 4:06 p.m.
I'm familiar with the data warehouse tables, but it's not always obvious as to which field types populate which tables.  You said "Custom HTML attributes are available" but how do I know where that data goes?  Do I assume it goes in the REQUEST_STRING_L_EXT table, along with the Large String attributes? It would be nice if this was clarified.

Permanent link
Francesco Chiossi
(5.7k●1●11●19) edited
Feb 23 '16, 8:37 a.m.
Hello Jackie,

to my knowledge there isn't a list like this (would be nice to have).

The closest resource I can think of is the data dictionary:

Custom Attribute
https://jazz.net/help-dev/clm/index.jsp?re=1&topic=/com.ibm.team.reports.doc/topics/ccm/Custom-Attribute.html&scope=null

Best Regards,

Francesco Chiossi

0 votes

Comments
Jackie Albert
Feb 22 '16, 1:01 p.m.
I did check the data dictionary to see if it had anything on the topic, however since these are custom attributes they wouldn't be found.

Francesco Chiossi
Feb 23 '16, 8:47 a.m.
Hello Jackie, sorry I pasted the wrong link (now corrected). The Custom Attribute page of the data dictionary gives a hint to which DW tables correspond the RTC custom attribute. I'm not sure however if it's a complete list. Best Regards, Francesco Chiossi

Permanent link
Rafik Jaouani
JAZZ DEVELOPER (5.0k●1●6) May 03 '17, 1:32 p.m.

 You can create a report in report builder that uses the custom attributes and look at the generated SQL.

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
× 11,105

Question asked: Feb 22 '16, 9:36 a.m.

Question was seen: 7,793 times

Last updated: May 03 '17, 1:32 p.m.

Confirmation Cancel Confirm