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

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

Questions
Tags
Users
Badges
Torin Denniston
(15●1●8●11) May 05 '15, 2:45 p.m.
Hello,

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!

0 votes

2 answers
9,811 views
0 votes

Accepted answer

Permanent link
Alanna Zito
JAZZ DEVELOPER (1.4k●1●3) 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:

https://<server>:<port>/ccm/rpt/repository/workitem?fields=workitem/workItem/comments/*
Torin Denniston selected this answer as the correct answer

1 vote

Comments
Torin Denniston
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
JAZZ DEVELOPER 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: https://www-01.ibm.com/support/knowledgecenter/SSYMRC_5.0.2/com.ibm.team.reports.doc/topics/r_ccm_rest_api.html 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 - https://jazz.net/wiki/bin/view/Main/ReportsRESTAPI#Getting_a_schema_for_a_resource).

One other answer

Permanent link
Kenji Sarai
(960●3●9) 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?
http://www-01.ibm.com/support/knowledgecenter/SSYMRC_5.0.2/com.ibm.team.reports.doc/topics/ccm/Work-Item.html

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.

0 votes

Comments
Torin Denniston
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 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
× 7,622
× 403
× 333
× 136

Question asked: May 05 '15, 2:45 p.m.

Question was seen: 9,811 times

Last updated: May 07 '15, 11:49 a.m.

Confirmation Cancel Confirm