Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

The documents below demonstrate examples both in Word and Excel templates that iterates over the issue's changelogs.


word.pngIterating_Issue_History.docx
Iterating_Issue_History.xlsx

...

Code Block
titleExpand to see the sample code
collapsetrue
#{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}

NoteWhen 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.

word.pngImage ModifiedIterating_Issue_Links.docx
Image ModifiedIterating_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
titleExpand to see the sample code
collapsetrue
#{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.

word.pngImage ModifiedIterating_Issue_Comments.docx
Image ModifiedIterating_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
titleExpand to see the sample code
collapsetrue
#{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.

word.pngImage ModifiedIterating_Issue_Worklogs.docx
Image ModifiedIterating_Issue_Worklogs.xlsx

...

Code Block
titleExpand to see the sample code
collapsetrue
#{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.

word.pngImage ModifiedIterating_Issue_Components.docx
Image ModifiedIterating_Issue_Components.xlsx

...

Code Block
titleExpand to see the sample code
collapsetrue
#{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.

word.pngImage ModifiedIterating_Issue_AttachedImages.docx
Image ModifiedIterating_Issue_AttachedImages.xlsx

...

Code Block
titleExpand to see the sample code
collapsetrue
#{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.

word.pngImage ModifiedIterating_Issue_ProjectVersions.docx
Image ModifiedIterating_Issue_ProjectVersions.xlsx

...

Code Block
titleExpand to see the sample code
collapsetrue
#{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.

word.pngImage ModifiedIterating_Issue_Commits.docx
Image ModifiedIterating_Issue_Commits.xlsx

...

Code Block
titleExpand to see the sample code
collapsetrue
#{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.

word.pngImage ModifiedIterating_Issue_Branches.docx
Image ModifiedIterating_Issue_Branches.xlsx

...

Code Block
titleExpand to see the sample code
collapsetrue
#{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.

word.pngImage ModifiedIterating_Issue_PullRequests.docx
Image ModifiedIterating_Issue_PullRequests.xlsx

...

Code Block
titleExpand to see the sample code
collapsetrue
#{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.

word.pngImage ModifiedIterating_Issue_Builds.docx
Image ModifiedIterating_Issue_Builds.xlsx

...

Code Block
titleExpand to see the sample code
collapsetrue
#{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.

word.pngImage ModifiedIterating_Issue_Reviews.docx
Image ModifiedIterating_Issue_Reviews.xlsx

...

Code Block
titleExpand to see the sample code
collapsetrue
&{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.

word.pngImage ModifiedIterating_Issue_Parents.docx
Image ModifiedIterating_Issue_Parents.xlsx

...

Code Block
titleExpand to see the sample code
collapsetrue
#{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.

word.pngImage ModifiedIterating_IssuesInEpic.docx
Image ModifiedIterating_IssuesInEpic.xlsx

...

The documents below demonstrate examples both in Word and Excel templates with JQL examples.


word.pngIterating_JQLQueries.docx
Iterating_JQLQueries.xlsx

...