It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Follow this question
Question details

×11,931
×10,908

question asked: Mar 12 '14, 11:49 a.m.
question was seen: 4,023 times
last updated: Mar 14 '14, 12:50 p.m.

Related questions

FAQ - How this Forum works

Locating specific data warehouse tables that contain custom fields and their corresponding data.

0
Jon Chinnery (10●5●5) | asked Mar 12 '14, 11:49 a.m.
I have customized the CCM application to capture custom attributes against defects. Example - I added a field for capturing 'defect category'. All the system field data is flowing from RQM CCM to 'Request' table of DW. But we need to find the DW tables which store the custom field data.

Accepted answer

1
permanent link
Clara Forero (621●2) | answered Mar 14 '14, 12:50 p.m.
JAZZ DEVELOPER

Hi Jon,

These are the tables where you can find request related custom attributes (all of them are in the RICALM schema): REQUEST_COMPONENT_EXT, REQUEST_CATEGORY_EXT,  REQUEST_RESOURCE_EXT, REQUEST_RELEASE_EXT, REQUEST_ITERATION_EXT, REQUEST_PROJECT_EXT, REQUEST_TEAM_EXT, REQUEST_TIMELINE_EXT, EQUEST_REQUEST_EXT, REQUEST_INT_EXT, REQUEST_LONG_EXT, REQUEST_BOOL_EXT, REQUEST_STRING_EXT, REQUEST_STRING_M_EXT, REQUEST_STRING_L_EXT, REQUEST_TIMESTAMP_EXT, REQUEST_DECIMAL_EXT.

Thanks,

Clara

 

,

Jon Chinnery selected this answer as the correct answer

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.