What custom RTC fields are available in the data warehouse?

Jackie Albert (1.6k●1●49●46) | asked 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?

3 answers

Most liked answers ↑|Newest answers|Oldest answers

permanent link

Kot T. (1.5k●1●12●19) | answered Feb 22 '16, 3:39 p.m.
JAZZ DEVELOPER

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.

Comments

Jackie Albert commented 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) | answered Feb 22 '16, 11:59 a.m.
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

Comments

Jackie Albert commented 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 commented 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

0	permanent link Rafik Jaouani (5.0k●1●6) \| answered May 03 '17, 1:32 p.m. JAZZ DEVELOPER You can create a report in report builder that uses the custom attributes and look at the generated SQL.

It's all about the answers!

Related questions

What custom RTC fields are available in the data warehouse?

3 answers

Your answer