How to Export Work Items Selecting by Statuses into Different Sheets
To export a tracker with work items that have different statuses, select them selecting by their statuses each statuses goes to a dedicated sheet of the excel workbook.
You can do this by applying a pre-filtering groovy script, where you can filter the required work items from the item set before you use it in the for cycle.
In the Groovy script, items are collected in an array named filteredItems:
<cb:groovy template="false" silent="true">
filteredItems = [];
items.each({
if (it.getStatus().getName() == "To Do") {
filteredItems.add(it);
}
});
</cb:groovy>
Your main for cycle go through the items of this array:
<jt:forEach items="${filteredItems}" var="item">${item.id}
In the Excel template, the description is formatted and only the plain text of the descriptions is displayed. The length is limited to 1000 characters
${StringUtils:abbreviate(textFormatter.formatAsText(item.description, item.descriptionFormat, request, item), 1000)}