send email for filter results using Jira automation

[Mariam Mohamed]

I need to send email for filter results and I want to use Jira automation and not filter subscription. The challenge is to have single email including filter results (like the filter subscription) but let's say we have daily basis schedule then I don't want to receive in email what I have received yesterday and I only want to get the new tickets all in single email.

Note my main concern is to have single email for filter results in Jira automation tool

[Vishal Biyani · Accepted solution]

@Mariam Mohamed 

Assuming you are looking for an idea as to how to implement the automation, you can do below

• Add a custom field (or use labels) to track which issues have sent the previous day
• Create a scheduled trigger and the time when you want to run it. in the same trigger add the JQL that you want to run. Add additional condition to check if newly added custom field is Empty.
• Add the send email action (sample) and configure the receipients

The following tickets were updated in the last 24 hours:

{{#lookupIssues}}

- *{{key}}* - {{summary}} (Updated: {{updated.format("yyyy-MM-dd HH:mm")}})

{{/}}

• update the newly added custom field for the issues that were returned above with say current date

[Mariam Mohamed]

Thanks Vishal for the helpful answer, here's what worked for me: add schedule trigger --> add lookupissues action --> send email with {{#lookupIssues}}.

[Callum Carlile _Automation Consultants_]

Hi @Mariam Mohamed 

If you just add AND created >= -24h to whatever JQL you are using to filter the results, this will only fetch issues that were created in the last 24 hours, and if your rule is scheduled to run once every 24 hours then this should only find the issues that were created between now and the last time the rule was run.

Hope this helps!

[Mariam Mohamed]

actually here I'm using custom date and the jql filter is for outdated tickets, I will keep your answer in mind for any future requirements, thank you!