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

How do I get statistics on requirement composer comments

Questions
Tags
Users
Badges
Steve McDuff
(3●1●3●5) Nov 06 '13, 11:36 a.m.
 Hi,

I'm looking for a way to extract statistics on review comments across an entire project area.

For instance:
- How many comments were posted between a start date and an end date.
- How were they distributed among comment authors
- How were they distributed among comment recipients
- How many of those comments are closed/open

Do I need to go through the data warehouse report generation tool, or is there an easy way to extract this information ? 

Ideally, this could be done through a widget in a dashboard using live data.

Thanks,

0 votes

Comments
Paul Verrone
Oct 16 '14, 8:33 a.m.
I'm looking to do the same.  I viewed the data warehouse schema and don't see any fields that look like they capture comment information.  Did you ever figure out a way to do this?

Steve McDuff
Oct 16 '14, 9:11 a.m.
 Yes, I managed to do it but it wasn't easy. I used the REST API built on top of RRC in conjunction with some data extraction scripts (grep). The API allows users to run a single query that will return every comment on the system. The result can be quite large and take a long time to generate. ( I wouldn't be surprised if it could cause out of memory exceptions on the server ) https://jazz.net/wiki/bin/view/Main/RRCReportableRestAPI

0 answers
6,753 views
0 votes

Be the first one to answer this question!

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,144

Question asked: Nov 06 '13, 11:36 a.m.

Question was seen: 6,753 times

Last updated: Oct 16 '14, 9:11 a.m.

Confirmation Cancel Confirm