...
Changes to issues are registered in the Issue History, but it is not known in advance how many changes are going to be made. You can iterate a section over all the history entries of an issue. This allows you to create a table that dynamically grows according to the number of changes denedone. The notation is:
Field | Description | ||||||||
---|---|---|---|---|---|---|---|---|---|
HistoryEntriesCount | Returns the number of changes made. | ||||||||
Author | Returns the user who made the change. | ||||||||
Created | Date of the change | ||||||||
ChangedItemsCout | Returns the number of fields changed in the current change. | ||||||||
ChangedItem |
|
Code Block | ||||
---|---|---|---|---|
| ||||
#{for historyEntries} ${fullname:HistoryEntries[n].Author} made changes ${dateformat("dd-MM-yyyy HH:mm:ss"):HistoryEntries[n].Created} #{for ch=HistoryEntries[n].ChangedItemsCount} Field Name: ${HistoryEntries[n].ChangedItems[ch].Field} Old Value: ${HistoryEntries[n].ChangedItems[ch].From} New Value: ${HistoryEntries[n].ChangedItems[ch].To} #{end} #{end} or #{for <VariableName>=HistoryEntriesCount} Content and Issue History Mappings. Example:${fullname:HistoryEntries[VariableName].Field} #{end} |
The documents below demonstrate examples both in Word and Excel templates that iterates over the issue's changelogs.
Iterating_Issue_History.docx
Iterating_Issue_History.xlsx
...
The documents below demonstrate examples both in Word and Excel templates that iterate over the activity from the issues.
Iterating_Issue_Activity.docx
Iterating_Issue_Activity.xlsx
...
Field | Description | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
AppType | The application type of the link
| ||||||||||
LinkType | The type of the link | ||||||||||
Key | The key of the linked issue | ||||||||||
Summary | The summary of the linked issue | ||||||||||
URL | The URL of the link |
...
Note: When the link you are iterating is of AppTypes External Jira or Confluence, the name is obtained using the Summary property.
The documents below demonstrate examples both in Word and Excel templates that iterate over linked issues.
Iterating_Issue_Links.docx
Iterating_Issue_Links.xlsx
...
The documents below demonstrate examples both in Word and Excel templates that iterates over the issue comments.
Iterating_Issue_Comments.docx
Iterating_Issue_Comments.xlsx
...
The documents below demonstrate examples both in Word and Excel templates that iterates over the issue worklogs.
Iterating_Issue_Worklogs.docx
Iterating_Issue_Worklogs.xlsx
...
For an example of how to iterate the details of a subtask Parent issue, please check the Iterating JQL Queries.
The documents below demonstrate examples both in Word and Excel templates that iterates over the issue subtasks.
Iterating_Issue_Subtasks.docx
Iterating_Issue_Subtasks.xlsx
...
The documents below demonstrate examples both in Word and Excel templates that iterates over the issue components.
Iterating_Issue_Components.docx
Iterating_Issue_Components.xlsx
...
The documents below demonstrate examples both in Word and Excel templates that iterates over the issue status transitions.
Iterating_Issue_StatusTransitions.docx
Iterating_Issue_StatusTransitions.xlsx
Iterating Issue Attached Images
Because it is not known in advance how many Images can exist for an issue (as an attachment), you can iterate a section over all the attached images of an issue to get some metadata about them. This allows you to create a table that dynamically grows according to the number of existing images. The notation is:
...
The documents below demonstrate examples both in Word and Excel templates that iterate over the attached images for each issue.
Iterating_Issue_AttachedImages.docx
Iterating_Issue_AttachedImages.xlsx
Info |
---|
|
Since Xporter 5.5.0, you can use the width and height of the mapping to define the exact width and height of the printed image.
...
The documents below demonstrate examples both in Word and Excel templates that iterates over the issue's attachments.
Iterating_Issue_Attachments.docx
Iterating_Issue_Attachments.xlsx
...
The documents below demonstrate examples both in Word and Excel templates that iterates over the issue's labels.
Iterating_Issue_Labels.docx
Iterating_Issue_Labels.xlsx
...
The documents below demonstrate examples both in Word and Excel templates that iterates over the issue's project versions.
Iterating_Issue_ProjectVersions.docx
Iterating_Issue_ProjectVersions.xlsx
...
The documents below demonstrate examples both in Word and Excel templates that iterates over the issue's commits.
Iterating_Issue_Commits.docx
Iterating_Issue_Commits.xlsx
...
The documents below demonstrate examples both in Word and Excel templates that iterates over the issue's branches.
Iterating_Issue_Branches.docx
Iterating_Issue_Branches.xlsx
...
The documents below demonstrate examples both in Word and Excel templates that iterates over the issue's pull requests.
Iterating_Issue_PullRequests.docx
Iterating_Issue_PullRequests.xlsx
...
The documents below demonstrate examples both in Word and Excel templates that iterates over the issue's builds.
Iterating_Issue_Builds.docx
Iterating_Issue_Builds.xlsx
...
The documents below demonstrate examples both in Word and Excel templates that iterates over the issue's reviews.
Iterating_Issue_Reviews.docx
Iterating_Issue_Reviews.xlsx
...
The documents below demonstrate examples both in Word and Excel templates that iterates over the parent issues.
Iterating_Issue_Parents.docx
Iterating_Issue_Parents.xlsx
...
Iterating Issues In Epic
All fields listed here are available on IssuesInEpic[n] because they represent an issue.
...
The documents below demonstrate examples both in Word and Excel templates that iterates over the issues in epic.
Iterating_IssuesInEpic.docx
Iterating_IssuesInEpic.xlsx
...
The documents below demonstrate examples both in Word and Excel templates with JQL examples.
Iterating_JQLQueries.docx
Iterating_JQLQueries.xlsx
Info |
---|
You can also use a Filter Name or a Filter Id as a clause. For more info, check [http://confluence.xpand-addons.com/display/public/XPORTER/JQL] |
...
Applying filters to Iterations
If you want to take the previous iterations over comments, subtasks, and issue links to another level of control, you can use a JavaScript filter to define over which issues the iteration will be made. This can be useful in the following scenarios:
...