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.