Creating a list of open subtasks in an automation table that lists all parent tickets

[Christy Kennedy]

Here is the goal of my Automation:

Every Friday, I want to send an email that contains a table listing all issues in the statuses "Compliance Approval", "On Hold", or "Awaiting approval". Each issue should show in a separate row of the table. (I have this working successfully).

Problem:

I am running into problems when I want to include a list of all open subtasks for each of the parent issues in their respective rows. I assume I need to use {{lookupIssues}}, but I cannot figure out how to associate the open subtasks with their parent tickets when adding them to the table.

---

Here is what the table looks like in the email:

---

Here is the Automation I made:

---

And here is the HTML I use to create the table (I left the cell for Open Subtasks blank - that is where I need help):

<style type="text/css">
.tg {border-collapse:collapse;border-spacing:0;}
.tg td{border-color:black;border-style:solid;border-width:1px;font-family:Arial, sans-serif;font-size:14px;
overflow:hidden;padding:10px 5px;word-break:normal;text-align:center;} /* Added text-align:center; */
.tg th{border-color:black;border-style:solid;border-width:1px;font-family:Arial, sans-serif;font-size:14px;
font-weight:normal;overflow:hidden;padding:10px 5px;word-break:normal;text-align:center;} /* Added text-align:center; */
.tg .tg-582d{background-color:#63B9BE;border-color:inherit;color:#FFF;font-weight:bold;text-align:center;vertical-align:middle}
.tg .tg-0lax{text-align:left;vertical-align:top}
</style>
<table class="tg">
<thead>
<tr>
<th class="tg-582d">Issue Summary</th>
<th class="tg-582d">Date Created</th>
<th class="tg-582d">Issue Status</th>
<th class="tg-582d">Open Subtasks</th>
</tr>
</thead>
{{#lookupIssues}}
<tr>
<td class="tg-c3ow">{{summary}}</td>
<td class="tg-c3ow">{{created.mediumDate}}</td>
<td class="tg-0pky">{{status.name}}</td>
<td class="tg-0pky"> </td>
</tr>
{{/}}
</table>

[Kalyan Sattaluri · Accepted solution]

Hello @Christy Kennedy  Welcome.

When I tried to log below, I am getting the open subtasks

{{#lookupIssues}}{{#subtasks}}{{#if(equals(status.name,"To Do"))}}* {{key}} , {{summary}}{{/}}{{/}}{{/}}

Using that I have tried to update your email template but havent tried it. Can you check and let us know..

<table class="tg">
<thead>
<tr>
<th class="tg-582d">Issue Summary</th>
<th class="tg-582d">Date Created</th>
<th class="tg-582d">Issue Status</th>
<th class="tg-582d">Open Subtasks</th>
</tr>
</thead>
{{#lookupIssues}}
<tr>
<td class="tg-c3ow">{{summary}}</td>
<td class="tg-c3ow">{{created.mediumDate}}</td>
<td class="tg-0pky">{{status.name}}</td>
<td class="tg-0pky"> {{#subtasks}}{{#if(equals(status.name,"To Do"))}} *{{key}}{{/}}{{/}}{{/}}</td>
</tr>
{{/}}
</table>

[Christy Kennedy]

Thanks for the help @Kalyan Sattaluri I implemented this, but am getting the below error:

Error rendering smart-values when executing this rule

[Christy Kennedy]

Specifically it says 

Mismatched start/end tags: null != in template-[id number]

[Kalyan Sattaluri]

Oops. Please remove one of the closing paranthesis. Can you try below:

<table class="tg">
<thead>
<tr>
<th class="tg-582d">Issue Summary</th>
<th class="tg-582d">Date Created</th>
<th class="tg-582d">Issue Status</th>
<th class="tg-582d">Open Subtasks</th>
</tr>
</thead>
{{#lookupIssues}}
<tr>
<td class="tg-c3ow">{{summary}}</td>
<td class="tg-c3ow">{{created.mediumDate}}</td>
<td class="tg-0pky">{{status.name}}</td>
<td class="tg-0pky"> {{#subtasks}}{{#if(equals(status.name,"To Do"))}} *{{key}}{{/}}{{/}}</td>
</tr>
{{/}}
</table>

[Christy Kennedy]

Thanks! No errors this time, but the cells in the email table for "Open Subtasks" are just empty :(

I confirmed that there are subtasks in the "To Do" status on this project.

[Kalyan Sattaluri]

Hmm, Can you confirm what is the actual name of the status of Open sub-tasks. We call it as To Do.

Is yours  the same or is it different?

[Christy Kennedy]

The status options are "To Do" and "Done".

[Kalyan Sattaluri]

I just tested and it seemed to work for me including the email part.

Can you, after your lookup action and Before your email action, put a log action statement with below value and share your audit log screenshot.

{{#lookupIssues}}{{#subtasks}}{{#if(equals(status.name,"To Do"))}}* {{key}} , {{summary}}{{/}}{{/}}{{/}}

Please see my screenshots below:

Below is the email i got with open subtasks listed in my example:

[Christy Kennedy]

Aha! I changed it to find open subtasks using the resolution field instead. It worked :) 

<td class="tg-0pky"> {{#subtasks}}{{#if(equals(resolution, EMPTY))}} *{{key}}{{/}}{{/}}</td>

[Christy Kennedy]

Thanks again for all your help @Kalyan Sattaluri !

[Kalyan Sattaluri]

Awesome. Please consider accepting the solution so others researching in the future can benefit. Thanks!