How can I know my workitem data is stored in which table of database?
Pravin Patil (104●1●46●134)
| asked Aug 25 '17, 4:02 p.m.
retagged Sep 01 '17, 10:33 a.m. by Ken Tessier (841●1●7) 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
Ralph Schoon (63.5k●3●36●46)
| 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.
|
HI Pravin,
|
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.