It's all about the answers!

Ask a question

Is there a way to query only the most recent comments?


Patrick Casey (111) | asked Jun 25 '18, 9:23 a.m.

I was able to build a query that built a table that included in it the comments on a work item.

However, as more comments get added, this field can get bloated and make the table unreasonably large.

Is there a way to have the query only extract the most recent comments? And if not, is there at least a way to organize it so that it displays the most recent comments first instead of last as it does by default?

Thank you!

One answer



permanent link
Ralph Schoon (63.2k33646) | answered Jun 25 '18, 10:45 a.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER

Hi, I am not aware that this is possible in the product. You could use https://github.com/jazz-community/work-item-command-line and basically adjust the ExportWorkItemsCommand.calculateCommentsAsString(IWorkItem workItem)

https://github.com/jazz-community/work-item-command-line/blob/master/com.ibm.js.team.workitem.commandline/src/com/ibm/js/team/workitem/commandline/commands/ExportWorkItemsCommand.java



Comments
Patrick Casey commented Jun 25 '18, 10:52 a.m.

I was hoping that there was a way to edit the query as a SQL thing, but I'll take a look at your suggestion, thanks!

Your answer


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.