Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Xporter - Word - text if JQLIssuesCount with |clause filter returns empty/no results

Pieter Kuppens
Contributor
April 1, 2020

I am exporting a Word document with meeting minutes.

I have a few sections with filters, e.g.

Section New Issues

#{for i=JQLIssuesCount|clause=${filter:10054}}

...

#{end}

Section In Progress

#{for i=JQLIssuesCount|clause=${filter:10055}}

...

#{end}

Section Blocked

#{for i=JQLIssuesCount|clause=${filter:10056}}

...

#{end}

However, I also want to show text if the result is empty. For each of the filters.

Is there a simple way, using a condition?

-- edited to better explain the problem after the first answer, I need this for each of the filters --

PS. in the end, I managed by setting an 'isEmpty' variable, but that is somewhat tedious and not very elegant. All examples in the Xporter Academy just use the for loop. The JQLIssuesCount gives the result of the filter I had to use to do a non-empty report.

PPS. A similar approach did not work for Excel as I expected, the '${set(count, 0)}` line seems to produce undesired empty rows.

1 answer

1 vote
José Domingues _Xray_
Atlassian Partner
April 21, 2020

Hi Pieter, 

You can try this option:

#{if (%{'${JQLIssuesCount}' = 0})} 
Does not have issues
#{end}

 

Best Regards,

Team Xporter

Suggest an answer

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

Atlassian Community Events