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

How can I know my workitem data is stored in which table of database?

Below are my RTC details:

version: 5.0.2
Database: Oracle 12C
Server OS: Windows 2012 R2 Standard

Below are the workitem details:
Workitem Type: SIR
Custom Attribute: 'Ticket Number'
Custom Attribute field type: Large HTML

Requirement:
How to find out which table/column in RTC database is the value for 'Ticket Number' stored? 
I want to retrieve this value from db via sql.

Please suggest.

0 votes



2 answers

Permanent link

As a user you have no business withthe DB. You can, if you have to access the API to access data. If needed, the reportable REST api https://jazz.net/help-dev/clm/index.jsp?topic=%2Fcom.ibm.team.reports.doc%2Ftopics%2Fr_ccm_rest_api.html could be used.

The application API is th e interface, not the DB.

1 vote


Permanent link

HI Pravin,
As Ralph explained, database scheme is not disclosed for RTC application, but it is disclosed for data warehouse. If you are running data collection job (aka ETL job) for RTC, then you might check the data in data warehouse instead. For example, run the following SQL commands:

connect to DW
select NAME, NUM_VAL, VAL from RICALM.REQUEST_STRING_L_EXT

then you will see all list of Request Large String type of custom attributes.

For the detail, see
https://jazz.net/help-dev/clm/topic/com.ibm.team.reports.doc/topics/ccm/Custom-Attribute.html

Note that data warehouse is retrieving data by Reportable REST, so the result will be the same regardless of which way you verify the data. 

1 vote

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
× 12,019
× 1,381

Question asked: Aug 25 '17, 4:02 p.m.

Question was seen: 2,828 times

Last updated: Sep 01 '17, 10:33 a.m.

Confirmation Cancel Confirm