It's all about the answers!

Ask a question

How to Report and Analyze on Discussion field?

Michael Alberda (2311043) | asked Oct 08 '15, 4:15 a.m.


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


Kind Regards,

Michael Alberda

Accepted answer

permanent link
Francesco Chiossi (5.7k11119) | answered Oct 08 '15, 4:24 a.m.
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

Best Regards,

Francesco Chiossi
Michael Alberda selected this answer as the correct answer

Michael Alberda commented 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.

Kind regards,
Michael Alberda

Francesco Chiossi commented 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 to post your answer.