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

Automation rule JIRA Audit logs missing and ran the rule for wrong issues

Karthikeyan_zq6p3w

We have an automation rule running in agile JIRA. The intention of this rule is to send mail notifications to Assignee every Wednesday for the issues that has crossed due date.

It is suppose to send mails to the issues that is returned through JQL. But instead it sends mail to not related items as well.

And also, For the last trigger on 30th of November 2022 Wednesday, mails are sent to wrong items and interestingly audit logs are not found.

Rule name: Wednesday - Mail sent to Assignee every Wed if issue has crossed due date

Project Key: APPSECVM

JQL: (project in (50453)) AND (project = "Application Security-Vulnerability Management" AND type = Bug AND duedate < now() AND status not in (Closed, Fixed, Resolved, Done, Archived, Canceled, Cancelled, Deferred) AND assignee is not EMPTY)

Screenshot 1 : Audit logs missing for 30th

Screenshot 2 : Sent mail label shows the right issues picked as part of the JQL, but mails are sent not only to this, but sent to other issues that are not passing the JQL condition.

Accepted answers

Tom Lister_fo1j4e

HI @Karthikeyan

Is it possible to see what you are configuring in your email clause. When you say sent to other issues, do you mean assignees of tickets that are not passed due date?

I think you could also achieve the same outcome by using a filter subscription scheduled for Wednesday with JQL as


(project = "Application Security-Vulnerability Management" 
AND type = Bug 
AND duedate < now() 
AND status not in (Closed, Fixed, Resolved, Done, Archived, Canceled, Cancelled, Deferred) 
AND assignee is currentUser())

is this the JQL you are using or that shown in the screenshot.


 (project in (50453)) AND 
(project = "Application Security-Vulnerability Management" 
AND type = Bug 
AND duedate < now() 
AND status not in (Closed, Fixed, Resolved, Done, Archived, Canceled, Cancelled, Deferred) 
AND assignee is not EMPTY)

This will return all item in 50543 plus the items select in the second clause

Unless you have a custom field called type should it have "issuetype = Bug"

Does "AND status not in (Closed, Fixed, Resolved, Done, Archived, Canceled, Cancelled, Deferred) " mean the same as "resolution is EMPTY"

All comments

Tom Lister_fo1j4e

HI @Karthikeyan

Is it possible to see what you are configuring in your email clause. When you say sent to other issues, do you mean assignees of tickets that are not passed due date?

I think you could also achieve the same outcome by using a filter subscription scheduled for Wednesday with JQL as


(project = "Application Security-Vulnerability Management" 
AND type = Bug 
AND duedate < now() 
AND status not in (Closed, Fixed, Resolved, Done, Archived, Canceled, Cancelled, Deferred) 
AND assignee is currentUser())

is this the JQL you are using or that shown in the screenshot.


 (project in (50453)) AND 
(project = "Application Security-Vulnerability Management" 
AND type = Bug 
AND duedate < now() 
AND status not in (Closed, Fixed, Resolved, Done, Archived, Canceled, Cancelled, Deferred) 
AND assignee is not EMPTY)

This will return all item in 50543 plus the items select in the second clause

Unless you have a custom field called type should it have "issuetype = Bug"

Does "AND status not in (Closed, Fixed, Resolved, Done, Archived, Canceled, Cancelled, Deferred) " mean the same as "resolution is EMPTY"

Karthikeyan_zq6p3w

This is my email clause.

When i say other issues, i mean that issues that are not part of the JQL outcome. For eg, APPSECVM-249 has crossed due date, but it is resolved. So it shouldn't be sent mail. I am not seeing this issue listed when i run the JQL but mails are sent.

This is my JQL and this is the same that is visible in screenshot

This JQL yields me the right result. But i am wondering why it is behaving differently while running in rules. For eg, only 7 items you see in the sent mail of screenshot2 is supposed to be sent, but it picked many other items which are not met by the JQL condition.

I agree on the part of Resolution is empty. I can use that and issuetype as well.

Also, i mentioned about the Audit logs missing that is something to be noted.

Tom Lister_fo1j4e

Hi @Karthikeyan

The portion of the JQL "(project in (50453)) AND" isn't showing in the screen shot which is why I was curious as to its use. If present it would certainly give the effect you are getting i.e. all issues in 50543 are being included.

re runs have you got only recently updated issues set on

Screenshot 2022-12-01 at 13.27.33.png

This may limit the data available to run the automation.

Karthikeyan_zq6p3w

The portion of the JQL "(project in (50453)) AND" is automatically included in JQL when i

click the issues found of JQL. But anyway 50453 is still nothing but the APPSECVM project, which is not a problem.

And I cannot set this flag "Only include issues that have changed since the last time this rule executed". Because, irrespective of whether the issue is updated or not, i need to send mail to the assignee. This flag will omit the issues that are not changed, but the requirement is to cover them as well.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

server

jira

jira-server

agile