Automation - email on wroklog not updated

[POOBALAN MUNUSAMY]

I want to generate email automation to report on resources who didn't update their respective worklog the previous day.  what i get is empty mail ( refer attachment - mail.png ). Any miss in the settings ?

[Duc Thang TRAN]

Hello @POOBALAN MUNUSAMY 

If I understand your need correctly: the automation finds all assigned standard tickets (no epic or subtask) without work logged today, retrieves all assignee users, and sends this list to a team lead?

An empty list may be caused by an incorrect variable in your automation or how you're using this variable in the send email action. Can you share screenshots of these elements?

Also, the branch  in your automation (for stories)  will take child issues if the scheduled JQL retrieves an epic, and will ignore other issues (which is not ideal for me).
​

Simplified Alternatives
Create a filter with your JQL ex :  worklogDate < startOfDay() AND statusCategory != done AND assignee is not EMPTY and issuetype in (yours issuetypes)

and subscribe to it for daily emails to avoid automation complexity.
​

If you prefer automation for personalized emails:

Use a scheduled trigger without JQL.

Add a "Lookup issues" action with your full JQL to get the list of tickets (the number of tickets depends on the "Lookup issues" configuration in your Data Center; default is 100).

Use smart values like {{lookupIssues.assignee.displayName.distinct.join(", ")}} in the email body.

Hope this can help :)

[POOBALAN MUNUSAMY]

Hi Tran,

Yes, my objective is to check worklog across stories & subtasks and send the report the following day to reporting manager

refer to attachment, this settings incorrect ?. for test purpose, i set it to every 6 mins. Ithe idea is I want report to be generated the following workday only before 10am and send the report to manager

[Sebastian Krzewiński]

Hi @POOBALAN MUNUSAMY 

What is actual output of your rule? Is it working partially or nothing is working?

Regards,

Seba

[POOBALAN MUNUSAMY]

Hi Seba, I don't receive the expected output.. just the following

The following team members have not updated their worklogs within the required period:

Please ask them to update their Jira worklogs as per process.

Thanks,
Jira Automatio

[POOBALAN MUNUSAMY]

Hi Tran,

Whichever way to achieve the objective( send report to mgr on worklog status), whether using JQL or scheduled trigger without JQL..I'm fine

refer to screenshot, issuetype refers to ?