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

How to Report and Analyze on Discussion field?

Questions
Tags
Users
Badges
Michael Alberda
(23●1●16●48) Oct 08 '15, 4:15 a.m.

Hi,

We would like to do some sort of reporting/analysis on the discussion items logged against a work item e.g. How many discussions comments have been entered per day. What is the latest discussion item etc.

The discussion items do not get copied across to the DW. We were wondering if it will be possible to read the data/information from the actual DB. Please advise if possible and what that table/s would be

Thank-you,

Kind Regards,

Michael Alberda

0 votes

1 answer
4,891 views
0 votes

Accepted answer

Permanent link
Francesco Chiossi
(5.7k●1●11●19) edited
Oct 08 '15, 4:27 a.m.
Hello Michael,

direct access to the repository databases is not recommended or supported.
If you need to report on data that is not into the data warehouse, you should look into the Reportable REST API and either write your own code to access and parse the results, or use a reporting tool like Rational Publishing Engine.

For references on the Reportable  REST API see:

Reportable REST API
https://jazz.net/wiki/bin/view/Main/ReportsRESTAPI

Best Regards,

Francesco Chiossi
Michael Alberda selected this answer as the correct answer

0 votes

Comments
Michael Alberda
Oct 08 '15, 4:36 a.m.
Hi Francesco, Thank-you for your response. We understand that it is not reccommended but do you perhaps know which tables are used for the discussion field or where we can find such information? We are busy investigating the REST API. Thank-you, Kind regards, Michael Alberda

Francesco Chiossi
Oct 08 '15, 5:07 a.m.
Hello Michael, as far as I known the internal structure of the RTC repository is IBM proprietary information and not publicly documented. Best Regards, Francesco Chiossi

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.

Ask a question
Guidelines
FAQ
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,147
× 485

Question asked: Oct 08 '15, 4:15 a.m.

Question was seen: 4,891 times

Last updated: Oct 08 '15, 5:07 a.m.

Confirmation Cancel Confirm