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

Question

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 · Answer

As written, that rule will send a Slack message for every issue which has the Assignee noted in the first condition.  And because of the first condition, it will also never send the "nothing in progress" message.  Is that what you wanted?

Also, this rule will only work for that assignee, and no others.

I recommend pausing to clarify what problem you are trying to solve.  That is, "why do this?"  And then explain that problem to your Jira Site Admin to ask their opinion on how to solve it.

Petar Cvetanovic_jgriyv · Answer

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

Bill Sheboy · Answer

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