Xporter : Nested loop in excel don't work

Samuel-Alexandre Massot
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
February 21, 2024

Hello,

I want to generate a traceability matrix. I have a top level jira element "solution release" parent of changes(epics) parents of Stories.

In an excel document want to reflect this hierarchy in an excel document.

To start I tried this code in word document : 

#{for a=JQLIssuesCount|clause= parent = ${Key} and issuetype != Sub-task}
#{for n=jqlissues|clause= parent= ${JQLIssues[a].Key} and issuetype != Sub-task}
${JQLIssues[a].Key}         ${JQLIssues[a].IssueType}            ${JQLIssues[a].Summary}             ${JQLIssues[n].Key}                ${JQLIssues[n].Summary}
#{end}
#{end}  

This works fine.
When I try this code in excel I got a corrupted document.
 

My excel document is structured as followed

Row 1 merged colomns: 

#{for a=JQLIssuesCount|clause= parent = ${Key} and issuetype != Sub-task}
#{for n=jqlissues|clause= parent= ${JQLIssues[a].Key} and issuetype != Sub-task}

Row 2 (display in seperate columns)

${JQLIssues[a].Key}         ${JQLIssues[a].IssueType}            ${JQLIssues[a].Summary}             ${JQLIssues[n].Key}                ${JQLIssues[n].Summary}

Row 3 (merged columns)

#{end}
#{end} 

 

I tryied many combinations : one line, multiple merged rows for each loop. 

The only way to have a valid excel document is to get rid of the second nested loop.

 

I'd like to see logs somewhere but could not find on this forum a way of accessing jira logs on cloud instances.

What am I doing wrong ?

1 answer

0 votes
Aron Gombas _Midori_
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
February 21, 2024

As for the second part of the question, you can not  the Jira logs on Cloud.

What is the information you are looking for in the logs?

Samuel-Alexandre Massot
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
February 21, 2024

Thanks for the response for the logging part.

As I know Xporter generates errors in logs, but as this logs are not accessible in jira, this is really tricky to debug.

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
TAGS
AUG Leaders

Atlassian Community Events