nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Lookup Issues 2 Variables

Hagay_w4hjz9

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?

Accepted answers

Alex Koxaras -Relational-

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.

All comments

Alex Koxaras -Relational-

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_w4hjz9

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_w4hjz9

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.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

cloud

jira-software

jira-software-cloud