nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Automate spent time report

Chasovskikh Kirill

Hello!

Is it possible to automate daily report of spent time to all tasks for a user and send them to slack?

Accepted answers

All comments

Trudy P Claspill

Hello @Chasovskikh Kirill

Jira does not natively provide reporting capabilities to get the time logged per day per user.

To get such a report you would need to consider adding a third party app.

Mary from Planyway

Hi @Chasovskikh Kirill

It's Mary from Planyway

Yes, in Jira, it is possible to automate the creation of a daily report of time spent on all tasks for a user and send this report to Slack. This automation can be achieved by integrating Jira with Slack and using Jira's automation tools. Here's a general approach:

Jira and Slack Integration: First, ensure that Jira and Slack are integrated. This can be done through the Slack Marketplace where you can find apps that connect Jira with Slack.
Use Jira's Automation Feature:
- Jira offers a powerful automation engine that allows you to create custom rules. You can set up a rule to track time spent on tasks.
- The automation rule can be configured to trigger at a specific time each day (e.g., end of the day).
- The rule can collect data on the time logged by a specific user across all tasks for that day.
Creating the Report:
- The automation rule can be set to compile this data into a report format. This could involve summing up the total time spent, categorizing by task or project, etc.
Sending the Report to Slack:
- Once the report is generated, the automation rule can use the Jira-Slack integration to send this report to a designated Slack channel or directly to a user.
- You can customize the message format and the Slack recipient(s) as needed.
Additional Tools/Scripts:
- Depending on your specific needs and the complexity of the report, you might also consider using additional tools or scripts. For instance, if Jira's built-in automation doesn't meet all your requirements, you could use Jira's API in conjunction with a scripting language like Python to fetch the necessary data and format it, then use the Slack API to send the report.

Chasovskikh Kirill

Hi @Mary from Planyway

> The automation rule can be set to compile this data into a report format. This could involve summing up the total time spent, categorizing by task or project, etc.

Could you help, how to compile with automation worklog report for one user for one day from different tasks?

Chasovskikh Kirill

Hello @Trudy P Claspill

Perhaps, do you know any suitable plugins?

Trudy P Claspill

There are a variety of plugins that provide a variety of functionality for reporting on time logged.

I don't know if any of them specifically include functionality for generating a report on a scheduling and sending it in any manner (slack, email, etc.). You would need to review the capabilities of the plugins to determine that.

Here is a search from the Atlassian Marketplace to help you get started.

https://marketplace.atlassian.com/search?hosting=cloud&product=jira&query=time%20report

Mary from Planyway

@Chasovskikh Kirill

Hope it'll help:

Choose a trigger for your rule. Since you want a daily report, the trigger could be a "Scheduled" trigger, set to run at a specific time each day.
To gather worklogs for a specific user across different tasks, use JQL in the automation rule. Your JQL query might look something like this: worklogAuthor = currentUser() AND worklogDate >= startOfDay() AND worklogDate < endOfDay(). This query fetches all worklogs made by the current user during the current day.

Use the "Lookup issues" action with your JQL query to fetch the relevant tasks.
Next, add an action to process these issues. You might need to use a "Branch rule / related issues" action to iterate over each issue returned by the JQL query.
For each issue, extract the worklog details. This could involve summing up the time spent on each issue.

Chasovskikh Kirill

@Mary from Planyway

Thank you for the feedback!

To add values of worklog from all issues its possible to use

{{#lookupIssues}}
* {{key}} {{worklog.timeSpent}}
{{/}}

But, do you know how to obtain values only for today's worklogs? Condition

{{lookupIssues.worklog.started}} greater than startOfDay()

doesn't work.

Thank you in advance!

Chasovskikh Kirill

Thank you for the answer!

Yes, I've tried to find any plugins for time tracking, but the main problem is to find a plugin, that could send reports with webhooks.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

cloud

jira-cloud

report

slack