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.

Hi, I am not aware that this is possible in the product. You could use and basically adjust the ExportWorkItemsCommand.calculateCommentsAsString(IWorkItem workItem)

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.