Sending email to users logged less than 6 hours a day

[Alexey Byzov]

Good day,

we are using Jira cloud and users are logging time on the task they do. Would like to know if it is possible at the end of working day to send every user who logged less, than 6 hours total time email, saying: 

"Dear user, today you have logged less than 6 hours on your tasks, please review tasks and log time."

If it is possible (without additional paid plugins) please help to understand how.

Thank you!

[Bill Sheboy]

Hi @Alexey Byzov 

There isn't anything built-in which easily allows seeing the number of hours logged, day by day.

Three possible work-arounds are...

1. Using an automation rule running on a schedule for each open issue, call the REST API method to gather the worklog history, filter that by the current day, sum the results, and send the email if it is less than your threshold of 6 hours
2. Another possible rule without the call to the REST API could use a custom field (Last Remaining Estimate): using a scheduled trigger rule on open issues, compare the custom field to the current remaining estimate (within an if/else clause), and send the email if below your threshold.  At the end of your rule, update the custom field with the latest remaining estimate.  One problem with this rule is if you exceed the original estimate, I believe remaining estimate will stay at zero.
3. Check the Atlassian marketplace for addon tools which better help managing logged work time

Kind regards,
Bill

[Tharaka_Hettiarachchi]

Hi @Alexey Byzov ,

You can do this using Jira Automation.

1. Create a 'Scheduled' trigger everyday at a given time 

2. Create 'Advanced Compare Condition' to check the logged hours

3. Add 'New Action' -> Send Email

Cheers!

[Alexey Byzov]

Sorry, i do not get it.

How Auotmation will define user to send email to?

[Alexey Byzov]

And is it possible to get value {{worklog.updated.diff(now).hours}} - to put in templates in email?

[Wojciech Wardaszko]

{{worklog.updated.diff(now).hours}} returns the difference between now and the last update on the worklog, so if we check if it was updated in the last 6 hours we do not get the expected result - we just check if the last update to the worklogs on the issues in scope was within the last 6 hours. 

What @Alexey Byzov is asking for is to find and notify users who tracked less than 6 hours total in a given day.

I don't think it's possible in Jira itself without using external tools or apps. Honestly, I don't know of any app that has this capability at this time, but it may be worth the time to look up free time-tracking apps in the Marketplace.

Our App, Clockwork Free, does not have this capability at this time. We are working on something related, but have nothing to show for it yet.