Jira Automation says "no actions performed" because of "no related issues", but there are issues!

[Tomalin Jenner]

I want to create an automation to send a Slack message out for all issues in Jira that follow this criterion:

1. Are in a specific board

2. Are a specific issue type

2. Have the tiered custom field be values "Tier 1" or "Tier 2" (the custom field currently works by having the issue creator initially select "Tier 1", which will then show a dropdown of "Client 1", "Client 2", "Client 3" etc.)

3. Have a due date of 6 months from today

My intention is to get an automated update 6 months before the due date of the tasks that meet the above criterion.

I have tried creating the rule by:

1. Having a "when" function to run the automation every day
2. Generating an "if" function for "Issue matches JQL" using the following JQL:
   1. project = "XX- Project Name -XX" AND issuetype = "XX- Issue Type Name -XX" AND duedate = endOfDay("+183d") AND ("Tiers & Clients[Select List (cascading)]" = "Tier 1" OR "Tiers & Clients[Select List (cascading)]" = "Tier 2")
3. Generating a "Then" function for 'Send Slack Message' & added my Webhook URL with the following message:
   1. Renewal Reminder: **{{issue.customfield_XXX}}** is due on {{issue.duedate.format("yyyy-MM-dd")}}.

I validated the query and it said there were 2 issues found, but when running the automation, the audit log said that no actions were performed because 'no related issues could be found'.

I also tried using an "if or else" function by adding conditions based on 'JQL condition' to segment out each of the JQL requirements 

Could I please have some suggestions for what I'm doing wrong here or what a better way to do this could be?

[Admin Jovanio]

You alredy validade if this scope rule is global?

Maybe this is the problem. The rule don't be found this tickets the your jql.

[Bill Sheboy]

Hi @Tomalin Jenner -- Welcome to the Atlassian Community!

For a question like this, context is important for the community to help.  Please post the following:

• an image of your complete automation rule in a single image for continuity
• images of any relevant actions / conditions / branches
• an image of the audit log details showing the rule execution
• explain what is not working as expected and why you believe that to be the case

Until we see those...

Do you want to send one single Slack message with a list of work items or a separate message for each work item?  The answer may impact how your rule is structured.

And, you probably want the JQL to handle the testing and not use a rule condition for this scenario.

Kind regards,
Bill