Excel Template Comments/attachments

Labisch — Thu, 18 Jul 2024 11:08:46 GMT

Hello,

based on https://codebeamer.com/cb/wiki/1563473 and the example there, I try to export more than just comment (at.description).

Mainly, I look for the template code to get the user who created the comment, but I'd appreciate a (link to) the full structure definition much more.

So far I tried ( <jt:forEach items="${item.attachments}" var="at">${at.id}</jt:forEach>)

at.createdBy (gives me an empty cell)

at.name (filename of the attachment)

at.createdAt (two comma seperated numbers... any hints?)

at.id (not sure which id I get her, I guess the comment's id)

at.version (seems like the version of the comment)

at.comment (mostly empty. Once I got the text "description" which is nowhere in the item. It was only in a comment which was edited and had version=2)

Re: Excel Template Comments/attachments

Istvan_Molnar — Tue, 03 Sep 2024 10:57:47 GMT

Hello @Labisch, please try the attached template, hope this answers your question.

The following attributes are exported:

Comment - ${at.description}
Commented at - ${at.createdAt}
Commented by - ${at.owner.name}

topic Re: Excel Template Comments/attachments in Codebeamer

Excel Template Comments/attachments

Re: Excel Template Comments/attachments