Send slack message if user doesn't have in progress issues

[Petar Cvetanovic]

I want to create automation for 33 employees that i am managing. 
The automation should following:

1. Filter all task per specific assignee
2. Check if filtered issues statuses and if the assignee doesn't have issues in "in progress" status, send a Slack message reminder.

The biggest problem that i don't know how to handle is how do do the second part

Important - check video explanation - 

https://www.loom.com/share/95178fb0b3424663a88110d8c08be406

[Bill Sheboy]

Hi @Petar Cvetanovic 

With the changes to Slack REST API, it is no longer possible for a Jira Automation rule to send a direct message to a specific Slack user using the Atlassian-provided Slack connector.  (Although the Atlassian documentation and UX have not updated to note that yet.)  

Instead, one may send to a specific channel and mention the particular user if you have their Slack ID.

If you have a different connector for Jira to Slack, please investigate that app's documentation to learn if there is a REST API endpoint for sending direct messages.

Kind regards,
Bill

[Petar Cvetanovic]

Sending Slack messages is not a problem. We can do it in the channels. The problem is how to 

Filter all tasks per specific assignee, check filtered issues statuses, and if the assignee doesn't have issues in "in progress" status, do some action (send in slack message in channel)

[Bill Sheboy]

Without seeing the specifics of your automation rule, I am guessing it uses the Lookup Issues action to find the issues and send the list.

In that case, either the JQL could be adjusted or the smart value, list filtering could be used:

https://community.atlassian.com/t5/Automation-articles/Filtering-smart-value-lists/ba-p/1827588

[Petar Cvetanovic]

Hey, grateful for helping me. Here is the logic that i am using and for some reason, it's sending both messages.

1. I filter all issues assigned to a specific assigned.

2. If specific assignee has issues in progress i send the message - "Nothing user has "In Progress" issues

ELSE send reminder message

Where i am wrong?

Video explanation -
Part 1 - https://www.loom.com/share/b0b23def404d4b9faf60f33687c34c04?focus_title=1&muted=1&from_recorder=1 
Part 2 - https://www.loom.com/share/f9e8bc2005774e29904b480ae8a2dd89