JQL Query in Xporter Word Export

[oliver b_]

I am trying to get a list of defects associated to affectedVersions within a Test Plan. 

My Query sofar:

${set(count_defect,0)}
#{for c=JQLIssuesCount|clause=project = ${ProjectKey} AND issuetype = Defect AND affectedVersion in ("PROJ_BO_2.3.34.14.40", "PROJ_BO_2.3.34.14.41")}
${set(count_defect,%{${count_defect} + 1})}
#{end}
Number of Defects: ${count_defect}

Currently I am inserting the AffectedVersions manually. I would like to have that taken from the Test Plans FixVersion

I am sure there is a simple solution, but my Xporter skills are not that good (yet). 

Thanks!

[Rogério Paiva - Xray Xporter]

Hi @oliver b_ 

You may try the following:

• Add a For loop (before the  code you shown above) to list the Test Plans you wish to get the FixVersion from,
• Inside this For loop, set a variable with the FixVersions; if necessary, use Javascript (https://confluence.getxray.app/display/public/XPORTER/JavaScript) to concatenate the values (in case it is a list),
• And in your code above, use the variable from the previous step. Either directly in the JQL or in a conditional block (https://confluence.getxray.app/display/public/XPORTER/Conditional+Blocks) inside the loop.

Thank you.

Kind regards,
Rogerio Paiva [Xporter Support Team]