Automation: Don't execute send if Lookup JQL has no results

[Michael Glick]

I'm trying to create an automation that sends a Slack message listing the Jira items that meet a certain JQL query. I was able to set that up with the following objects:

1. When: Schedule
2. Then: Lookup issues (with JQL query)
3. And: Send Slack message
   

   *The following items are open in JIRA*:
   
   {{#lookupIssues}}
   
   * <{{url}}|{{key}} - {{summary}}> [{{status.name}}] ({{assignee.displayName}})
   
   {{/}}

This works great, however it still sends that message even if there are no results from the Lookup's JQL query.

I tried wrapping it in an If-Then condition, but Jira then requires me to add the JQL to the Schedule component. By doing that it will then execute the Send Slack message component every time for each item in the JQL query results (which I obviously don't want to do).

What's the solution here?

[Mikael Sandberg · Accepted solution]

You should be able to do this by checking the size of the list and then configure your if condition similar to this

[Michael Glick]

That makes sense, but how would I check the size of the list?

[Mikael Sandberg]

The {{lookupIssues}} is a list, so all you have to do to get the size is to add .size to it like this {{lookupIssues.size}}. There are also other smart values that you can use with a list, check out https://support.atlassian.com/cloud-automation/docs/jira-smart-values-lists

[Kat Bruno]

@Michael Glick Did you figure this out using list? If so, could you share?

I see that using Advanced Compare Condition with {{lookupIssues.size}} greater than 0 works.

Thanks for this thread!