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; } } }

How do I automate using a Jira lookup list with conditional logic for the issue's component?

Lindsay Sullivan

Background:

I have used a successful automation for over a year that looks up the tickets completed in the last week, and emails:

a list of the completed tickets, matching the condition of specific epic link

This is the successful automation's content:

LOOKUP ISSUES operation - JQL is:
1. project = "PROJECT NAME" AND status changed TO "Done" AFTER -7d
EMAIL - content:
1. <strong>Back Office Functionality</strong>
  {{#lookupIssues}}
  {{#if(equals(epic Link.key, "SMGPORTAL-2226"))}}
  <li><a href=https://cylogy.jira.com/servicedesk/customer/portal/8/{{key}}>{{key}}</a> | {{summary}} ({{website}})</li>
  {{/}}
  {{/}}
2. This repeats for 5 different epic links

The email looks like:

Title

TICKET-123 | Name of ticket (website)
TICKET-124 | Name of ticket (website)
TICKET-125 | Name of ticket (website)

(repeated for 5 different epic links)

My problem:

I need to organize this list based on the component now, not the epic link. I can not find a smart value for the component that works. I have tried all the below. I have read all the documentation and searched other community posts. All my tests return no results.

My request:

Please advise what should replace epic Link.key for component name?
- Or is there a different syntax to achieve my outcome?

I am looking for the same email outcome as above, but it will be based on the component instead of epic link.

What I've tried, with no success:

{{#lookupIssues}}
{{#if(contains(issue.components.name, "Back Office Functionality"))}}

{{#lookupIssues}}
{{#if(contains(issue.component.name, "Back Office Functionality"))}}

{{#lookupIssues}}
{{#if(contains(components.name, "Back Office Functionality"))}}

{{#lookupIssues}}
{{#if(contains(issue.component, "Back Office Functionality"))}}

{{#lookupIssues}}
{{#if(contains(issue.components, "Back Office Functionality"))}}

{{#lookupIssues}}
{{#if(contains(ComponentName, "Back Office Functionality"))}}

Accepted answers

Bill Sheboy

Hi @Lindsay Sullivan

In my experience...Components are one of those smart values which behave like a list and an array in rules, depending upon the context. To do what you ask, please try this:

{{#lookupIssues}}{{#if(components.name.match("(blue comp)").size.gt(0))}}{{key}}; {{/}}{{/}}

How this works:

Iterate over the looked up issues
Filtering on the components field's name attribute with the match() function to iterate over the name values, filtering for one value. In my example, I am looking for "blue comp".
The match result will be a list, and so we use the size of the list, and only proceed if the number is greater than 0. (It really can only be null or 1, but this syntax handles the null better.)
When found, return the issue key

Please adjust for your component values and whatever you need returned from the lookup.

Kind regards,
Bill

All comments

Kalyan Sattaluri_iinm1n

Hi @Lindsay Sullivan

Based on how fixVersion works, I would have expected {{lookupIssues.components.name}} to work, at least to print them out.. But its not. Guess its one of them fields which isnt exposed in lookupIssues data.

Hopefully others can share if they are able to make it work.

*if* components is not exposed through lookupIssues but you still want to do it, you may have to make a REST call to search for the issues and implement this logic that way.

Bill Sheboy

Hi @Lindsay Sullivan

In my experience...Components are one of those smart values which behave like a list and an array in rules, depending upon the context. To do what you ask, please try this:

{{#lookupIssues}}{{#if(components.name.match("(blue comp)").size.gt(0))}}{{key}}; {{/}}{{/}}

How this works:

Iterate over the looked up issues
Filtering on the components field's name attribute with the match() function to iterate over the name values, filtering for one value. In my example, I am looking for "blue comp".
The match result will be a list, and so we use the size of the list, and only proceed if the number is greater than 0. (It really can only be null or 1, but this syntax handles the null better.)
When found, return the issue key

Please adjust for your component values and whatever you need returned from the lookup.

Kind regards,
Bill

Lindsay Sullivan

Hi @Bill Sheboy ,

I should have posted this months ago.... that totally worked.

How did you learn that? I haven't seen that syntax in the smart value and lookup documentation.

Final outcome:

<strong>Back Office Functionality</strong>

{{#lookupIssues}}{{#if(components.name.match("(Back Office Functionality)").size.gt(0))}}<li><a href=https://cylogy.jira.com/servicedesk/customer/portal/8/{{key}}>{{key}}</a> | {{summary}} ({{website}})</li>{{/}}{{/}}

Looks like:

Title

TICKET-123 | Name of ticket (website)
TICKET-124 | Name of ticket (website)
TICKET-125 | Name of ticket (website)

(repeated for 5 different components)

Thank you!

Lindsay

Bill Sheboy

Awesome; I am glad to learn that helped!

I have learned many things about automation rules by experimentation and reading posts in the community. I recommend watching the automation product area for new articles and discussions: