On the third In this exercise, you'll learn how to export information from JQL Queries.
...
| Info |
|---|
The clause is a query in JQL. You can check For more details, check here. The clause can be copy/pasted from the JQL of Jira advanced search for issues. If the clause JQL is valid, it will be valid in the template. |
...
In order to begin iterating the JQLissues with a clause, on at the beginning of the iteration section of your template you must , put the mapping #{for i=JQLIssuesCount|clause=project = ACADEMY}, and on at the end of that section, you must put the mapping #{end} to close it.
| Info |
|---|
On the example clause, I use we used ACADEMY because the name of my our project is ACADEMY. You have to put Put the name of your project. Also, you can use a placeholders on the clause(e.g. #{for i=JQLIssuesCount|clause=project = ${ProjectKey}} ) |
You must take into account that since Since you're iterating, you've to put JQLIssues[i]. on at the beginning of the mapping of the JQLIssues Field you're trying to populate.
| Info |
|---|
Using the JQLIssuesCount mapping inside your iteration will return the count of issues that you have on the clause. With the JQLIssuesCount iteration, you can populate the fields that you have on the issue. The fields you You can find it the fields here. |
When using the #{for i=JQLIssuesCount|clause=project = ACADEMY} statement, you must use one variable name like i, . If you want to use a different variable name, like a, you must start your iteration instead with the statement #{for a=JQLIssuesCount|clause=project = ACADEMY} and must make sure to change it properly on the JQLIssues[a]. on at the beginning of the mapping of the Issue Field you're trying to populate.
| Code Block | ||||
|---|---|---|---|---|
| ||||
#{for i=JQLIssuesCount|clause=project = ACADEMY }
Key: ${JQLIssues[i].Key}
Summary: ${JQLIssues[i].Summary}
#{end}
|
| Info |
|---|
Using an XLSX template however, please take note that to define an When defining an iteration for multiple columns of an XLSX template, you need to merge a row of columns and define the #{for i=JQLIssuesCount|clause=project = ACADEMY} inside that the merged cells. The same thing should be made to define the #{end} of the same iteration. All content between the #{for i=JQLIssuesCount|clause=project = ACADEMY} definition and the #{end} will be duplicated for each issue returned by the JQL clause. For further information more details, please check our documentation here. |
Below there is a sample of how the mappings will be displayed in an Excel template:
...
| Info |
|---|
If you like this exercise, please share your opinion on the page by just leaving leave a comment or a Thank you in advance. Enjoy our product. |
. Your 
| Expand | ||||||
|---|---|---|---|---|---|---|
| ||||||
Here 's the Exercise 3 related Xlsx filesare the files related to this Exercise:
|