RTC Query to add work item comments/discussion area
Accepted answer
5 other answers
Comments
Sure but the discussion area is just like a forum so I should be able to export/print out some type of line by line with timestamp and person and put their comments. no different then doing a print screen from this, I get all the comment information. I can click on each task, print and I get all the discussion area with all other fields. But I want a report that will do this for all open tasks, not have to click one by one to get it printed or exported.
Have you got any further in showing the comments in a report?
I'm working on an RPE Report where the customer needs to see the last comment on any defect.
It is possible to query the comments for defects in a given project area. However, I still don't have a way to select a specific comment out of the complete collection.
There is an attribute commentCount in the Workitem schema, but it doesn't seem to be linked to the comment itself.
Any ideas on how to select a single Comment to include it in a report?
You should be able to do this using the REST API, whether as a stand-alone application interfacing with CLM or with a report that operates on live data like a BIRT report or an RPE template.
Basically, you would execute a REST API query against the target workitem and specify in your XPATH that you want to see the comment information. Then your code would iterate over the comments and print the last one.
Refer to this site for an explanation of the REST API: