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

Is there a way to add a comment from the "discussion" section of a task into a table in ReportBuilder?

Questions
Tags
Users
Badges
Patrick Casey
(11●1) retagged
Jun 22 '18, 2:05 p.m.

Hi,

I am trying to generate a table that includes information on the current status of several tasks in ReportBuilder.

I was hoping to include as a part of this a section that contains the text of the a recent comment made in the discussion section as a way to provide a little more information on the task status.

However, I did not see "discussion" as one of the attributes that can be included in a report.

Does anyone know if this is something that can be done?

Thank you!

0 votes

Comments
Matt Muller
Jun 22 '18, 6:29 a.m.
Hi Patrick, If you want to show it on a Dashboard may have something to try: I've tried this without success using Report Builder;  however was able to build a quick Query with the Comments filed added to the result: After running the query  Select the option on the Right hand side "View  Full Results in a printable format" Copy the URL. Add an External Content Widget to your dashboard and enter the URL. Worth a try?

Patrick Casey
Jun 22 '18, 11:28 a.m.
Matt, thanks! That did exactly what I was looking for, and being on the dashboard ended up being more convenient than the reportbuilder anyways. Do you happen to also know if there's a way to make it so that it only shows the most recent comment as well?

1 answer
5,224 views
0 votes

One answer

Permanent link
Kenji Sarai
(960●3●9) Jun 22 '18, 4:24 a.m.

Hi Patrick,

If you are using Data warehouse data source, it is not possible because DCC job does not extract workitem discussion into RIODS.REQUEST table. Discussion can be huge so it is called "Document" rather than "Report".

If you have an RPE, then it is possible to get discussion data by "comments" field.
https://jazz.net/wiki/bin/view/Main/ReportsRESTAPI

But I am afraid it is a bit tricky to sort the discussion order in the output document.

0 votes

Your answer

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

Question asked: Jun 18 '18, 3:18 p.m.

Question was seen: 5,224 times

Last updated: Jun 22 '18, 2:05 p.m.

Confirmation Cancel Confirm