Page tree

Versions Compared

Key

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

...

Status Transitions FieldsDescription
AuthorThe author of the status transition
CreatedThe date the status transition was performed
CreatedDateThe date the status transition was performed
CreatedDateTimeThe date the status transition was performed
OldStatusThe old status of the status transition
NewStatusThe new status of the status transition
Code Block
titleExpand to see the sample code
collapsetrue
#{for statusTransitions}
   ${StatusTransitions[n].Author}
   ${dateformat("dd-MM-yyyy HH:mm:ss"):StatusTransitions[n].Created}
   ${dateformat("dd-MM-yyyy HH:mm:ss"):StatusTransitions[n].OldStatusCreatedDate}
   ${dateformat("dd-MM-yyyy HH:mm:ss"):StatusTransitions[n].NewStatusCreatedDateTime}
#{end}   or  
#{for <VariableName>=StatusTransitionsCount${StatusTransitions[n].OldStatus}
   ${StatusTransitions[n].NewStatus}
#{end}
 
or
 
#{for <VariableName>=StatusTransitionsCount}
   Content and StatusTransitions Mappings. Example: ${StatusTransitions[VariableName].Field}
#{end}

...

The documents below demonstrate examples both in Word and Excel template that iterates over the issue status transitions.

Image Removed

or

Image Removed

The image below demonstrates an example of an Excel template that iterates over status transitions.

Image Removed

or

...

Image Added Iterating_Issue_StatusTransitions.docx

Image Added 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:

Attachments Images FieldsDescription
IDThe ID of the attached image
ImageThe image of the attached image
NameThe name of the attached image
SizeThe size of the attached image
HumanReadableSizeThe size of the attached image
AuthorThe author (ID) of the attached image
CreatedThe date the attached image was created
CreatedDateThe date the attached image was created
CreatedDateTimeThe date the attached image was created
MimeTypeThe type of the attached image
ThumbnailURLThe URL to the thumbnail of the image
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}
   ${dateformat("dd-MM-yyyy HH:mm:ss"):Images[n].AuthorCreatedDate}
   ${dateformat("dd-MM-yyyy HH:mm:ss"):Images[n].CreatedCreatedDateTime}
   ${Images[n].MimeType}
   ${Images[n].ThumbnailURL}
 #{end}
 
or
 
#{for <VariableName>=ImagesCount}
   Content and Images Mappings. Example: ${Images[VariableName].Field}
#{end}

The image below demonstrates an example of a Word template that iterates over attached images. 

Image Removed 

or

Image RemovedThe documents below demonstrate examples both in Word and Excel template that iterates over the issue status transitions.

Image Added Iterating_Issue_Images.docx

Image Added Iterating_Issue_Images.xlsx


Info

You can iterate over ${Images[n].Image} in Excel on Xporter version 5.4.0 and above.

Info

Xporter will automatically read the EXIF orientation property of an image and rotate it to its correct orientation. You can turn this off by adding this property to your template.

...

Info

Note that, if you use both maxWidth and width mappings, only the max value will be read. The same behavior happens with height and maxHeight.

The image below demonstrates an example of an Excel template that iterates over attached images. 

Image Removed 

or

Image Removed

Info

You can iterate over ${Images[n].Image} in Excel on Xporter version 5.4.0 and above.

Iterating Issue Attachments

...