Background I'm trying to create an automation that identifies team members who haven't logged work for the previous day and sends a notification to Microsoft Teams. Current Setup JQL Query 1 - All Sprint Assignees jql project = Digi and Sprint in openSprints() and issuetype IN (Sub-task, Task, Bug) Smart Value Used: {{lookupIssues.assignee.accountId.distinct}} Variable Name: allAssignees Purpose: Get all users assigned to issues in active sprints JQL Query 2 - Users Who Logged Yesterday jql project = Digi and Sprint in openSprints() and issuetype IN (Sub-task, Task, Bug) and worklogDate = -1d Smart Value Used: {{lookupIssues.worklog.author.accountId.distinct}} Variable Name: loggedAssignees Purpose: Get users who logged work yesterday What I Need Help With I need to: * Compare the two arrays (allAssignees vs loggedAssignees) * Find users who are in allAssignees but NOT in loggedAssignees * Send the list of non-logging users to Microsoft Teams Questions * How can I perform array comparison in Smart Values? Is there a way to find the difference between two arrays of account IDs? * What's the best approach for this logic? Should I:* Use conditional logic with {{#if}} statements? * Iterate through one array and check against the other? * Use a different Smart Values function I'm not aware of? * How do I convert account IDs back to display names for the Teams message? Desired Output A Teams message like: ⚠️ Daily Timesheet Reminder The following team members haven't logged work for yesterday: - John Doe - Jane Smith

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

Smart Values Logic to Compare Two JQL Results and Find Non-Logging Users

Venkatesh G_fgma6a

Background

I'm trying to create an automation that identifies team members who haven't logged work for the previous day and sends a notification to Microsoft Teams.

Current Setup

JQL Query 1 - All Sprint Assignees

jql

<span>project = Digi and Sprint in openSprints() and issuetype IN (Sub-task, Task, Bug)</span>

Smart Value Used: {{lookupIssues.assignee.accountId.distinct}}
Variable Name: allAssignees
Purpose: Get all users assigned to issues in active sprints

JQL Query 2 - Users Who Logged Yesterday

jql

<span>project = Digi and Sprint in openSprints() and issuetype IN (Sub-task, Task, Bug) and worklogDate = -1d</span>

Smart Value Used: {{lookupIssues.worklog.author.accountId.distinct}}
Variable Name: loggedAssignees
Purpose: Get users who logged work yesterday

What I Need Help With

I need to:

Compare the two arrays (allAssignees vs loggedAssignees)
Find users who are in allAssignees but NOT in loggedAssignees
Send the list of non-logging users to Microsoft Teams

Questions

How can I perform array comparison in Smart Values? Is there a way to find the difference between two arrays of account IDs?
What's the best approach for this logic? Should I:
- Use conditional logic with {{#if}} statements?
- Iterate through one array and check against the other?
- Use a different Smart Values function I'm not aware of?
How do I convert account IDs back to display names for the Teams message?

Desired Output

A Teams message like:

<span>&#9888;&#65039; Daily Timesheet Reminder</span><span>The following team members haven't logged work for yesterday:</span><span>- John Doe</span><span>- Jane Smith</span>

Accepted answers

Bill Sheboy

Hi @Venkatesh G

Please see my response to a similar question which uses a dynamic regular expression to find the difference between two lists of values:

https://community.atlassian.com/forums/Automation-questions/Re-How-can-I-compare-two-smart-value-arrays-and-return-o/qaq-p/3041765/comment-id/14435#M14435

Kind regards,
Bill

All comments

Bill Sheboy

Hi @Venkatesh G

Please see my response to a similar question which uses a dynamic regular expression to find the difference between two lists of values:

https://community.atlassian.com/forums/Automation-questions/Re-How-can-I-compare-two-smart-value-arrays-and-return-o/qaq-p/3041765/comment-id/14435#M14435

Kind regards,
Bill

Venkatesh G_fgma6a

Dear @Bill Sheboy

I tried understanding it, but it is more complex for me to understand as per my needs. Can you explain it as per my requirement ?

Bill Sheboy

That linked post and this article explain the steps:

https://community.atlassian.com/forums/Automation-articles/Automation-concepts-Find-Overlaps-Between-Lists/ba-p/3045704

Please show what you have tried thus far to solve this for your rule, and explain what is not working as expected. That will provide more context to offer suggestions.

From your original question, the likely variation is because you are storing the account ID lists as variables they are text and not lists of values. They must be first split() into lists before proceeding with the steps, such as with:

{{allAssignees.split(", ")}}

Venkatesh G_fgma6a

Thanks @Bill Sheboy . Hereby i am enclosing screenshots and the steps i have achieved as of now .

As mentioned first, I have checked all assignees in the sprint using JQL and stored it in Variable "allAssignees"

Screenshot 2025-06-18 at 9.14.02 AM.png

Followed by i am checking the users who has logged on previous day

Screenshot 2025-06-18 at 9.14.14 AM.png

Screenshot 2025-06-18 at 9.14.42 AM.png

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-cloud

variable

smart-value