...
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
...
Code Block | ||||
---|---|---|---|---|
| ||||
#{for links} ${Links[n].AppType} ${Links[n].LinkType} ${Links[n].Key} ${Links[n].Summary} ${Links[n].URL} #{end} or #{for <VariableName>=LinksCount} Content and Linked Issue Mappings. Example: ${Links[VariableName].Field} #{end} |
Note: When the link you are iterating is of AppTypes External Jira or Confluenceor 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
...
Iterating Issue Comments
Because it is not known in advance how many comments exist for an issue, you can iterate a section over all the comments on an issue. This allows you to create a table that dynamically grows according to the number of existing comments. The notation is:
...
Code Block | ||||
---|---|---|---|---|
| ||||
#{for comments} ${Comments[n].Author} ${Comments[n].AuthorFullName} ${Comments[n].Body} ${dateformat("dd-MM-yyyy HH:mm:ss"):Comments[n].Created} ${Comments[n].GroupLevel} #{end} or #{for <VariableName>=CommentsCount} Content and Issue Mappings. Example: ${Comments[VariableName].Field} #{end} |
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
...
Iterating Issue Worklogs
Because it is not known in advance how many worklogs exist for an issue, you can iterate a section over all the worklogs of an issue. This allows you to create a table that dynamically grows according to the number of existing worklogs. The notation is:
...
Code Block | ||||
---|---|---|---|---|
| ||||
#{for worklogs} ${Worklogs[n].Author} ${Worklogs[n].AuthorFullName} ${Worklogs[n].Comment} ${dateformat("dd-MM-yyyy HH:mm:ss"):Worklogs[n].Created} ${dateformat("dd-MM-yyyy HH:mm:ss"):Worklogs[n].Date Started} ${Worklogs[n].Time Spent} ${Worklogs[n].TimeSpentFormatted} ${Worklogs[n].BilledHours} ${Worklogs[n].BilledHoursFormatted} #{end} or #{for <VariableName>=WorklogsCount} Content and Worklog Mappings. Example: ${Worklogs[VariableName].Field} #{end} |
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
...
Code Block | ||||
---|---|---|---|---|
| ||||
#{for components} ${Components[n].Name} ${Components[n].Description} ${fullname:Components[n].Lead} ${Components[n].Id} ${Components[n].ProjectId} ${Components[n].AssigneeType} #{end} OR #{for <VariableName>=ComponentsCount} Content and Issue Mappings. Example: ${Components[VariableName].Field} #{end} |
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
...
Code Block | ||||
---|---|---|---|---|
| ||||
#{for images} ${Images[n].Image|maxwidth=150|maxheight=150} ${Images[n].Name} ${Images[n].ID} ${Images[n].Size} ${Images[n].HumanReadableSize} ${Images[n].Author} ${dateformat("dd-MM-yyyy HH:mm:ss"):Images[n].Created} ${Images[n].MimeType} ${Images[n].ThumbnailURL} #{end} or #{for <VariableName>=ImagesCount} Content and Images Mappings. Example: ${Images[VariableName].Field} #{end} |
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
...
Code Block | ||||
---|---|---|---|---|
| ||||
#{for projectVersions} ${ProjectVersions[n].Name} ${ProjectVersions[n].Description} ${dateformat("dd-MM-yyyy"):ProjectVersions[n].Start date} ${dateformat("dd-MM-yyyy"):ProjectVersions[n].Release date} #{end} or #{for <VariableName>=ProjectVersionsCount} ${ProjectVersions[VariableName].Name} ${ProjectVersions[VariableName].Description} ${dateformat("dd-MM-yyyy"):ProjectVersions[VariableName].Start date} ${dateformat("dd-MM-yyyy"):ProjectVersions[VariableName].Release date} #{end} |
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
...
Code Block | ||||
---|---|---|---|---|
| ||||
#{for commits} ${Commits[n].Author} ${Commits[n].URL} ${Commits[n].Message} ${Commits[n].CreatedDateTime} Here we have the FilesCount where we can get all the files associated with a commit. #{for m=Commits[n].FilesCount} ${Commit[n].FilesCount[m].Path} ${Commit[n].FilesCount[m].URL} ${Commit[n].FilesCount[m].ChangeType} #{end} #{end} or #{for <VariableName>=CommitsCount} Content and Issue Mappings. Example: ${Commits[VariableName].Field} #{end} |
The 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
...
Code Block | ||||
---|---|---|---|---|
| ||||
#{for branches} ${Branches[n].URL} ${Branches[n].Name} ${Branches[n].RepositoryName} ${Branches[n].RepositoryURL} #{end} or #{for <VariableName>=BranchesCount} Content and Issue Mappings. Example: ${Branches[VariableName].Field} #{end} |
The 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
...
Code Block | ||||
---|---|---|---|---|
| ||||
#{for pullRequests} ${PullRequests[n].URL} ${PullRequests[n].Name} ${PullRequests[n].RepositoryName} ${PullRequests[n].RepositoryURL} ${PullRequests[n].CommentsCount} (This represents the number of comments in a pull request) ${PullRequests[n].Status} ${PullRequests[n].LastUpdated} Here we have the PullRequestReviews where we can get all the reviewers for this pull request. #{for m=PullRequests[n].PullRequestReviewers} ${PullRequests[n].PullRequestReviewers[m].Name} ${PullRequests[n].PullRequestReviewers[m].Approved} #{end} #{end} or #{for <VariableName>=PullRequestsCount} Content and Issue Mappings. Example: ${PullRequests[VariableName].Field} #{end} |
The 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
...
Code Block | ||||
---|---|---|---|---|
| ||||
#{for builds} ${Builds[n].ProjectName} ${Builds[n].ProjectKey} Here we have the each Build Plans where we can get all the individual plans for this project and the correspondent build in existence for this plan. #{for m=Builds[n].Plans} ${Builds[n].Plans[m].Key} ${Builds[n].Plans[m].Name} ${Builds[n].Plans[m].BuildNumber} ${Builds[n].Plans[m].BuildKey} ${Builds[n].Plans[m].BuildDuration} ${Builds[n].Plans[m].BuildFinishedDate} #{end} #{end} or #{for <VariableName>=BuildsCount} Content and Issue Mappings. Example: ${Builds[VariableName].Field} #{end} |
The 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
...
Code Block | ||||
---|---|---|---|---|
| ||||
#{for reviews} ${Reviews[n].Id} ${Reviews[n].URL} ${Reviews[n].Status} ${Reviews[n].Title} ${Reviews[n].Author} ${Reviews[n].Moderator} Here we have the Reviewers for each review where we can get all the individual reviewers for this review. #{for m=Reviews[n].Reviewers} ${Reviews[n].Reviewers[m].Username} ${Reviews[n].Reviewers[m].Completed} #{end} #{end} or #{for <VariableName>=ReviewsCount} Content and Issue Mappings. Example: ${Reviews[VariableName].Field} #{end} |
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
...
Code Block | ||||
---|---|---|---|---|
| ||||
&{for issues|filter=%{'${IssueTypeName}'.equals('Sub-task')}} ${Parent.Key} ${Parent.Summary} ${Parent.Description} ${wiki:Parent.Description} ${html:Parent.Description} ${dateformat(“dd-MM-yyyy HH:mm:ss”):Parent.date} ${emailaddress:Parent.userpicker} &{end} This example only has a few fields, but this new feature allows you to get all information from a parent issue. |
The documents below demonstrate examples both in Word and Excel templates that iterates over the the parent issues.
Iterating_Issue_Parents.docx
Iterating_Issue_Parents.xlsx
...
Code Block | ||||
---|---|---|---|---|
| ||||
#{for IssuesInEpic} ${IssuesInEpic[n].Key} ${IssuesInEpic[n].Summary} ${IssuesInEpic[n].Description} ${IssuesInEpic[n].Epic Link.Key} #{end} or #{for <VariableName>=IssuesInEpicCount} Content and Issue Mappings. Example: ${IssuesInEpic[VariableName].Field} #{end} |
The documents below demonstrate examples both in Word and Excel template 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
...