Jira automation to exclude issues sent last time in lookup issues

[Mariam Mohamed]

I have new automation and this is how it goes:

1- schedule: every day schedule (excluding issues that have changed since the last time this rule executed)

2- action: lookup issues action with jql filter

3- send email to designated users with the results of lookup issues

My problem is that "lookup issues" is bypassing the filter used in the schedule to exclude issues that have already been sent in email in previous execution.

How can I limit jql filter result in the "lookup issues" action to only include issues that have changed since the last time this rule executed. Note: using "created date" is not an option here.

[Tomislav Tobijas _Koios_]

Hi @Mariam Mohamed ,

As Lookup issues action is completely 'standalone action' > meaning it doesn't depend on the trigger (in your case Sheduled one) and any configuration set within this component.

That being said, you will have to 'exclude' any issues without changes by modifying the JQL used within this action.

I would suggest adding something like

updated >= -1d

as you mentioned your rule is scheduled to run daily.

This would then include only issues that have been updated within the last 24 hours.

Hope this helps.

Cheers,
Tobi

[Sam Thornton]

Good Morning Mariam,

Is this for Jira Service Management, or Jira (Software)?

In either case, I'd imagine that the separate JQL condition would be conflicting with the initial trigger.

If it's for JSM - The scheduled automation typically includes a JQL filter:

You'd use this to filter the issues you need, and then use the Action to send the email

Jira (Software) also has the same JQL filter when you select Scheduled as the trigger. In the basic view, this is at the bottom, and under the 'Advanced' tab, you need to select the checkbox to show the JQL filter.

You'd use this, and then add the Email action.

Could you give that a go and see how you get on, please?

Thanks!

[Cristian0791]

Hi Mariam,

If you are using Jira Service Management.

1.You can put the JQL condition on the step: When.

2. Check the box: Run a JQL search and execute for each issue in query

3.Check the box: Only include issues that have changed since the last time this rule executed.