Lookupissues not working as expected

[Sagi Gueta]

Hey,

I've created automation whose purpose is to apply each time a new worker finishes (status = done) their first 5 tasks (story/bug/task). The goal is to automatically send an email to certain users when the automation is triggered.

However, it's not working as expected as the automation requestor gets spam emails even if a user has much more than 5 issues that are done.

Any idea how to solve that problem?

to email certain users when it's happening automatically

[Trudy Claspill · Accepted solution]

Hello @Sagi Gueta 

Can you add a Log action to the rule to log the value {{lookupIssues.size}} to the rule Audit Log?

Can you show us the Audit Log for an execution of this rule?

[Sagi Gueta]

It seems that there is a success although the issue not meet the condition :(

[Bill Sheboy]

Hi @Sagi Gueta 

Adding to Trudy's questions/ideas...

This is configured as a multi-project/global scope rule, and so I wonder about consistency of the issue types and status values across the projects.  Regardless of that...

Please show the audit log details for a case where you believe an email was sent when the number of completed items did not equal 5.  And for that case, please use your lookup issue JQL with advanced search to compare to the results you believe the lookup received.

Kind regards,
Bill

[Trudy Claspill]

@Sagi Gueta 

Can you add a Log action to the rule to log the value {{lookupIssues.size}} to the rule Audit Log?

https://support.atlassian.com/cloud-automation/docs/jira-automation-actions/#Log-action

[Sagi Gueta]

I've added the log action at the bottom of the automation and the jira audit log wasn't affected :/

[Trudy Claspill]

The Log action prints data into the Rule's Audit Log, not the system Audit Log.

[Sagi Gueta]

OK :)

So basically I'm not sure if I configured it correctly as well, and still not sure how to fix that issue.. 

[Trudy Claspill]

You need to put the Log action before the IF/Compare action.

In this last execution you provided the IF/Compare condition has not been met. Lookup Issues found more than 5 issues that matched the JQL in your Lookup Issue action. Since the Compare failed, none of the remaining steps in the rule were executed.

[Alessandro Domanico]

Hi @Trudy Claspill

I'm also trying to debug my rule byt I get no output when logging {{lookupIssues.size}}.

In particular, I'm not able to insert in the email body a list of the fixed issue in a release.

What am I doing wrong? Thanks!

[Alessandro Domanico]

[SOLVED]

Sorry, just found out I was missing a "Lookup issue" action, needed to feed the variable {{lookupIssues}}.

Also, I need to use directly fields in the email body:

{{#lookupIssues}}
{{key}} - {{summary}}
{{/}}