Data in variable not showing in email.

Simon Sandrock

Hello, 

I am trying to create an automated mail that sends some information daily to people. 

The data is defect statistics. 

The first step is using issue lookup to get the list I want. 

I then assign it to a lookup table, the idea is that I need multiple sets of data in one email. Think of issues created that day and issues closed for example. In practice, the queries are a bit more complicated.

Now this works fine and gives me the full list when I send it like this 

{{#created.get("created1")}}
* {{key}} - {{summary}}
{{/}}

To add more I thought to use Lookup issues again and assign the result to a variable. And then add the variable to my lookup table. 

Which then looks like this 

First data set 

{{#created.get("created1")}}
* {{key}} - {{summary}}
{{/}}

Second data set 

{{#created.get("created2")}}
* {{key}} - {{summary}}
{{/}}

The problem is I tried it with the same data and the {{lookupIssues}} one does correctly show all result from the query but the one based on the variable does only show one entry. 

So how do I get both to show the full list? 

Thank you all very much for your time and help. 

 

Bill Sheboy

Hi @Simon Sandrock 

When you saved the first lookup result as a variable, that converted it all to text.  It is no longer a list of issue objects that can be parsed, iterated, etc.

Without knowing the specifics of your JQL for the lookups, there are three possible workarounds:

1. Use one Lookup Issues action, with JQL that spans both desired sets of issues.  Then use conditional logic (i.e., smart value, list filtering) for each measure / list of issues.
2. When you create the variable, iterate over the values to save only the Key and Summary, preformatted as you wish, and with a delimiter such as "~~".  Then when using the table value, split it back on "~~" to use the list items, without any {{key}} or {{summary}} attributes.
3. Use one Lookup and one Send Web Request action with a call to the REST API issue search to have two sets of issues.  Then the table is not needed as each result set may be iterated.

I recommend using the first one.  For example, let's say you wanted to list done and not-done issues.  That could be this:

Done Issues:
{{#lookupIssues}}
{{#if(equals(status.statusCategory.name,"Done"))}}* {{key}} - {{summary}}{{/}}
{{/}}

Not Done Issues:
{{#lookupIssues}}
{{#if(not(equals(status.statusCategory.name,"Done")))}}* {{key}} - {{summary}}{{/}}
{{/}}

Kind regards,
Bill