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

 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

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?

 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 )


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.

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

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

Question was seen: 4,337 times

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

Confirmation Cancel Confirm