Forums

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

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

desiree.molinero
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!
June 13, 2023

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. 

 

 

1 answer

0 votes
Aditya Verma
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
June 14, 2023

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

desiree.molinero
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!
June 16, 2023

Thank you

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
FREE
PERMISSIONS LEVEL
Product Admin
TAGS
AUG Leaders

Atlassian Community Events