How do I send an email where view all issues that status isn't done with automation rule

desiree.molinero

In automation rules I have created rule that every wednesday at 9:00 A.M search in JQL : (project in ("Ayuntamiento de Viladecans")) AND (Status != Done) ORDER BY created DESC and Send email with the results but  every issue found it sending in different Mails. 

How could I send an email with all issues that status isn't done in the same email as a list or table ? 

This is my actual code: 

<!DOCTYPE html>
<html>
<head>

<script ="text/javascript">

function runtable() {

count = 1;

var table = documentgetElementByID("Resultados");

for ( var i = 1; i< table.rows.lentgh; i ++); {

var fila = table.rows[i] ;

for (var j = 0; j < fila.cells.length; i++) {
var valor = fila.cells[j].innerHTML ;

Count+=1;

While Count <= i goto runtable() ;

console.log(valor);

}
}

}

</script>

<style type = "text/css">

</style>
</head>

<body>
<h3><b><u>Informe Setmanal : </u></b></h3>

Bon dia,

Us adjuntem l'Informe Setmanal amb detall actualitzat dels casos pendents i en curs.

<script ="text/javascript">

function runtable() {

count = 1;

var table = documentgetElementByID("Resultados");

for ( var i = 1; i< table.rows.lentgh; i ++); {

var fila = table.rows[i] ;

for (var j = 0; j < fila.cells.length; i++) {
var valor = fila.cells[j].innerHTML ;

Count+=1;

While Count <= i goto runtable() ;

console.log(valor);
}
}

}

</script>

<table id="runtable" style= "border: 1px black solid;" >
<tr>
<th ><u>Tipus de Tiquet</u></th>
<td>&nbsp;</td>
<th ><u>ID Ticket</u></th>
<td>&nbsp;</td>
<th ><u>Descripci&oacute;</u></th>
<td>&nbsp;</td>
<th ><u>Prioritat</u></th>
<td>&nbsp;</td>
<th><u>Estat</u></th>
<td>&nbsp;</td>
<th><u>Data Inici</u></th>
<td>&nbsp;</td>
<th ><u>Data Actualitzaci&oacute;</u></th>
<td>&nbsp;</td>
<th><u>Resoluci&oacute;</u></th>

</tr>

<tr>
<td style="border: 1px black solid ; text-align: center">
{{issue.issueType.name}}
</td>

<td>&nbsp;</td>

<td style="border: 1px black solid ; text-align: center">
{{issue.key}}
</td>

<td>&nbsp;</td>

<td style="border: 1px black solid ; text-align: center">
{{issue.summary}}
</td>

<td>&nbsp;</td>

<td style="border: 1px black solid ; text-align: center">
{{issue.priority.name}}
</td>

<td>&nbsp;</td>

<td style="border: 1px black solid ; text-align: center">
{{issue.status.name}}
</td>

<td>&nbsp;</td>

<td style="border: 1px black solid ; text-align: center">
{{issue.created}}
</td>

<td>&nbsp;</td>

<td style="border: 1px black solid ; text-align: center">
{{issue.updated}}
</td>

<td>&nbsp;</td>

<td style="border: 1px black solid ; text-align: center">
{{issue.resolution}}
</td>

</tr>

</table>

</body>

</html>

Thank you for your response. 

 

 

Aditya Verma

Hi @desiree.molinero ,

Welcome to the community!

Your use case seems to be a good fit for filter subscriptions. All you need to do is save your filter and schedule it as per your required frequency. You can refer this page for steps.

If you want to do this via Automation, please check this post for workarounds.

Thanks,
Aditya