Lookup Issues 2 Variables

[Hagay]

Hi,

Can a single automation create 2 variables from a "lookup issue"?

My intention is to send an email via automation, which will display result from 2 different lookups.

Lookup1 => Variable1 (list)

Lookup2 => Variable2 (list)

The email would display both lists.

Can this be done?

[Alex Koxaras _Relational_ · Accepted solution]

Hi @Hagay and welcome to the community

Unfortunately you can only have ONE lookup at a time. I mean you can place as many lookup components as you like, but every time you place, it will "erase" the previous lookup's results.

To your case I would either:

• Send two different emails on the same rule
  • Lookup1
    • Send email
  • Lookup2
    • Send 2nd email
• Create two different rules
• Use a webhook to get a JSON payload and then work with that in your email
• Try to store the lookup1 results on a new variable and then work with that. But keep in mind that most likely the new variable is going to be a text variable.

[Hagay]

Thanks Alex.

Sending two emails / creating two rules will both result in something different from what I want to achieve, so that irrelevant for me.

I didn't understand your last suggestion.

If it's possible, I can also combine both lookups to a single one, and split it when iterating, but I didn't find a way to do it. Something like an "if" clause within the loop

Lookup 1 results:
{{#lookupIssues}}
  * //IF CONDITION1 {{key}} - {{summary}}
{{/}}

Lookup 2 results:
{{#lookupIssues}}
  * //IF CONDITION2 {{key}} - {{summary}}
{{/}}

 Is something similar to this possible?

[Alex Koxaras _Relational_]

Conditional logic exists on smart values https://support.atlassian.com/cloud-automation/docs/jira-smart-values-conditional-logic/

However I'm not sure how you are going to use it, since {{lookupIssues}} will only yield results from one JQL.

Jira automation provides a component "Create variable". Read more here https://support.atlassian.com/cloud-automation/docs/jira-automation-actions/#Create-variable

[Hagay]

Issue solved.

I eventually did it by using a single JQL lookup, and then splitting the result using a condition. 

This was possible only because, luckily, the 2 lists I wanted to display are quite similar and can be fetched in a single JQL. The lists differ with a single attribute. Otherwise my solution wasn't useful.

Sketch:

<h3>First List</h3>
<ul>{{#lookupIssues}}
{{#if(key.startsWith("AAAA-"))}}
<li>{{key}} - {{summary}}</li>
{{/}}
{{/}}</ul>

<h3>Second List</h3>
<ul>{{#lookupIssues}}
{{#if(key.startsWith("BBBB-"))}}
<li>{{key}} - {{summary}}</li>
{{/}}
{{/}}</ul>

[Geetanjali Sharma]

Hi Hagay

I was trying to implement similar automation, and was able to figure out by declaring two variables and fetching the variable value in email. I have used two separate JQL  lookups and was able to format the list with the help of your sketch file.