How to Report and Analyze on Discussion field?
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
Accepted answer
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
Comments
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
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