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 (62.0k33643) | 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.