Cloud Automation Email - Show count of issues in a table after filtering

Andrew_hw4dsy

Hello,

I have a table in Automation Send Email that is set up to filter tickets with either of 2 statuses instead of the full results of a JQL search:

 

<h2>List 2 filter: {{lookupIssues.size}}</h2>
<table cellspacing="1" cellpadding="5" border="0" bgcolor="#000000"><tr bgcolor="#ffffff"><td>Type</td><td>Key⠀⠀⠀</td><td>Summary</td><td>Status</td><td>Updated</td><td>Next Steps</td></tr>
{{#lookupIssues}}{{#if(or(status.name.startsWith("Status1"),status.name.startsWith("Status2")))}}
<tr bgcolor="#ffffff"><td>{{issueType.name}}</td><td>{{key}}</td><td>{{summary}}</td><td>{{status.name}}</td><td>{{updated.jqlDateTime}}</td><td>{{next steps}}</td></tr>{{/}}{{/}}</table>

 

How do I go about displaying the count of tickets in the table? lookupIssues.size shows the full count of tickets from the search.

 

Thank you.

 

Aron Gombas _Midori_

Options:

A) Fully in the email template. Use a counter set to zero before the "lookIssues", increment that within the "if" and display it that counter.

In the search. Create a copy of the original CQL adding the additional criteria:

<your original search> and status IN ("Status1", "Status2")

Then just use this CQL and don't change the email template.

C) In the search without copying the original search. Take the ID of the original CQL saved filter (if it is a saved filter) and use this CQL:

filter=<ID of your original save filter> and status IN ("Status1", "Status2")

Then just use this CQL and don't change the email template.

The nicety here is that it will not duplicate the original saved filter plus will adapt itself if that is changed. 

My order of preference:

C, B and only then A.