How to extract sum of user worklogs for previous week using Jira automation?

Menuka Mendis

Hi,

I am trying to setup a Jira automation rule to send up a notification to the Jira users in my instance if they have not logged a certain number of hours for a week. This notification willl serve its purpose as a reminder so that the assignees can go and complete their missing time entries for the previous week.

I have managed to setup the Jira automation rule upto some extent and I am stuck with the part where I need to extract the user's worklog sum for the past week and compare it against the defined value. 

Appreciate it if someone can help me out here. I will list down what I have managed to build up so far.

---

Variables:

{{issueAssignee}} > {{#lookupIssues.assignee.distinct}} {{displayName}} {{/}}

{{sumOfWorklogs}} > {{lookupIssues.worklog.timeSpentSeconds.sum()}}

 

Wojciech Wardaszko_p20bth

Hi @Menuka Mendis

I think you posted the very same question on another account here.

Please see my reply in that thread and let me know if it helps.

Cheers!