It's all about the answers!

Ask a question

How do I get statistics on requirement composer comments

Steve McDuff (3135) | asked Nov 06 '13, 11:36 a.m.

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.


Paul Verrone commented 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 commented 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 )

Be the first one to answer this question!

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.