...
${set(count,%{${count} + 1})}Let's put the mappings that we want to print on the template.
Author | ${Comments[n].AuthorFullName} |
| Body | ${Comments[n].Body} |
Now,
We
are
going
to
use
the
function
continue
with
a
conditional
block.
#{if (%{'${Comments[n].Body}'.equals('Hello Continue')})}
Jump the next comment.
#{continue}
#{end} |
|---|
When the comment is equal a "Hello Continue" it is going to print the message "Jump the next comment" and the iteration goes to the next iteration. | Info |
|---|
We must have comments on your issue and a comment with "Hello Continue". |
...
Below the code above, we are going to put a conditional block that only print the message "Next comment", when the count of our set funciton is less than CommentsCount.
#{if (%{'${count}' < '${CommentsCount}'})} Next comment. #{end} |
|---|
Finally, close the iteration comments with
Using a XLSX template, please take note that to define an iteration for multiple columns, you need to merge a row of columns and define the &{for issues...} inside that merged cells. The same thing should be made to define the &{end} of the same iteration. All content between the &{for issues...} definition and the &{end} won't be duplicated for each iteration.
With that done, you create another row table where the Issue Comments will be populated:
${IssueTypeName} | ${Key} | ${Summary} | %{Number(“${OriginalEstimate}”/3600)} | %{Number(“${RemainingEstimate}”/3600)} | %{Number(“${TimeSpent}”/3600)} |
Finally close the statement using the mapping #{end}.
Well, the first sheet was completed. Let´s go to the second sheet.
We are going to create a pivot table.
A pivot table allows you to extract the significance from a large, detailed data set.
- To create a pivot table click on the first cell inside the header.
- On the Insert tab, click PivotTable
- A Dialog box appears. Excel automatically selects the data for you. The default location for a new pivot table is the New Worksheet.
- Click ok. The second sheet was created.
Now, The PivotTable fields list appears.
- The Field Key we are going to drag on the Rows.
- Estimated (Hours) we are going to drag on the Values.
- The Remaining (Hours) and Logged (Hours) we are going to repeat the step 2.
- For each Estimated (Hours), Remaining (Hours) and Logged (Hours) on the Values, we are going to set up a configuration.
- The configuration is right click and click on Value Field Settings.
- Choose the type of calculation you want to use. We are going to use the Sum.
- Click ok.
The configuration of pivot table is done but you are going to add a chart.
...
On the same template we are going to learn the iteration break.
Strating with the iteration #{for comments} or #{for <VariableName>=CommentsCount} statement.
Let's put the mappings that we want to print on the template.
Author | ${Comments[n].AuthorFullName} |
| Body | ${Comments[n].Body} |
Now, We are going to use the function break with a conditional block.
#{if (%{'${Comments[n].Body}'.equals('Hello Stop')})}
Finish the iteration of comments.
#{break}
#{end} |
|---|
When the comment is equal a "Hello Stop" it is going to print the message "Finish the iteration of comments" and the iteration goes to stop.
| Info |
|---|
We must have comments on your issue and a comment with "Hello Stop". |
Finally, close the iteration comments with #{end}.
...