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

Read data from db2 database to show on Jazz Web UI screen

I wanted to create a custom page on my RCT project area and display information about saved workitems, Is it possible to fetch data from from the database (db2), Is there any mapping i.e. what is the name of the table or column?

0 votes



2 answers

Permanent link

Hi Pankaj,

If you have your data in a dashboard widget you can export the widget and embed that in a web page.  Also, you can build a report in JRS and use the report URL in a page.

0 votes


Permanent link
I would advise against this idea as:

  • The RTC database schema is not public, as such it could change; having looked at it some, the work item is a representation backed by many tables and the configuration of each project area.
  • You will have difficulty even making a connection to the database which would require that your RTC provider be willing to allow. 
  • Assuming you could get the connection, it will bypass all access safeguards enforced by RTC.  For this reason alone we have turned this kind of request aside [ I am on a team that provides RTC service to several thousand users ].
  • There are numerous work item reports and viewlets designed for the purpose of displaying information
Just my $0.02.  

0 votes

Comments

Hello Kevin,
My requirement is displaying various attributes from different - different work item, in tabular form, Can you suggest me how that can be made.

Appreciate your help

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
× 10,926

Question asked: Nov 04 '15, 4:03 p.m.

Question was seen: 2,244 times

Last updated: Nov 05 '15, 8:18 a.m.

Confirmation Cancel Confirm