Having Work Item in Key-IDs format when exporting in excel

[JF_12205541]

Hello everyone,

I am currently working on a Excel template and I wanted to replace ${item.subjects} whose format is [Key-Id] - Name.

Some issues appear when I import back the file and I want to avoid them.

I wanted to export my upstream fields in a format : [Key-Id] format.

(The format is the same as the one added when Work Item Key-IDs Setting in a tracker.)

Do you know if there is a command like item.id or another way to create this format ? It seems easy but I did not find any documention mentioning a list of command available for default fields.

Thanks for your time 

Current view	Expected view

[EvaBertalan · Accepted solution]

Hello @JF_12205541 ,

Try this formula for the value of column E: 

[<jt:forEach items="${item.subjects}" var="upstream">${upstream.tracker.keyName}-${upstream.id}</jt:forEach>]