automation for summary of over due tasks sent over email

[Alkanz Ali]

I want to create an automation for summary of over due tasks sent over email to my manger on weekly basis

[Mohanraj Thangamuthu]

Hello, Good day. You can create a scheduled automation rule to run every week. JQL could be as following

project = projectname and duedate > StartofDay()

[Rilwan Ahmed]

Hi @Mohanraj Thangamuthu ,

This will not work as expected. Jira will send email for each tickets. 

i.e. if the JQL has 100 tickets, user will receive 100 emails. 

[Alkanz Ali]

yes i just want one email with all the tickets and the total no. summarised in a report/graph manner for my manager
100n emails will obviously piss him off

[Rilwan Ahmed]

Hi @Alkanz Ali ,

Go to Main Menu --> Filters --> View all Issues

Search for tickets with passed due dates.
Example: duedate <= startOfDay() and resolution = unresolved

Click "Save As" and give it a name. 

Share the url with your manager (example: https://XXXXXX.atlassian.net/issues/?filter=10012))
Ask him to Click Details --> New subscription. He can select the day and time when he needs the email.

If he is not ready to do that, add personal subscription and forward the emails when you receive them 

[Alkanz Ali]

this sounds like doable, let me have a look. Thanks