It's all about the answers!

Ask a question

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


Pravin Patil (104112108) | asked Aug 25 '17, 4:02 p.m.
retagged Sep 01 '17, 10:33 a.m. by Ken Tessier (84117)

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.

2 answers



permanent link
Ralph Schoon (57.7k23642) | answered Aug 26 '17, 4:55 p.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER

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.


permanent link
Kenji Sarai (96029) | answered Aug 27 '17, 10:44 p.m.

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. 

Your answer


Register or to post your answer.