It's all about the answers!

Ask a question

How do you pull defect/work item comments into reports in RPE/RRDI?

Torin Denniston (151811) | asked May 05 '15, 2:45 p.m.

My client has requested for my team to build a report that pulls the comments on Defects into a report, but so far we have been able to locate comments for Work Items in the data warehouse. What is the best practice for pulling comments on Defects into custom reports in RRDI and RPE?

We are currently using CLM v 5.0.2.

Thank you in advance!

Accepted answer

permanent link
Alanna Zito (1.3k3) | answered May 06 '15, 11:58 a.m.
Hi Torin,

The work item comments are not stored in the data warehouse, so they're not available in RRDI reports at all (as mentioned in the other answer, only the comment count is stored).

The comments are available via the reportable REST API however, so they could be included in an RPE report.  For example, the following URL would pull all work items with their comments:

Torin Denniston selected this answer as the correct answer

Torin Denniston commented May 07 '15, 11:30 a.m.

Thank you Alanna! This is exactly what I was looking for. Is there a data dictionary-style reference for URLs like the one above? The Data Dictionary seems to be missing references like the one you provided.

Alanna Zito commented May 07 '15, 11:49 a.m.

Yes, the data dictionary is a bit more geared towards data warehouse reporting, rather than live (RPE) reports.  For the reportable REST, take a look at this info center topic:

It links to some wiki pages that go into more detail about how to use the reportable REST API for RTC, and what kind of info is available.  Unfortunately, it looks like the wiki pages aren't completely up to date.  The best way to see exactly what data is currently available via the reportable REST is to take a look at the schema (as described here -

One other answer

permanent link
Kenji Sarai (96029) | answered May 05 '15, 10:35 p.m.
Hi Torin,

Discussion (# comments) is already loaded by OOTB configuration. See the link below. Is this what you are after?

If so, it is quite straight-forward.
From Query Studio (RRDI), drag and drop data item Operational Data Store/Request Area/Comment Count into the table. You will see a list of comments.
From RPE, define a datasource schema for RTC workitem (https://server:9443/ccm/rpt/repository/workitem?metadata=schema), and you will see workitem/workItem/commentCount. Drag and drop into Container to make a query.

Torin Denniston commented May 06 '15, 11:47 a.m.

Hi Kenji. While this is helpful, this is not what I was looking for. I am hoping to pull more than just the number of comments. I am hoping to see the actual content of the comments. Do you know if this is saved in the data warehouse?

Thank you for replying!

Your answer

Register or 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.