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 Work Log - Log 8h for everyday between two dates

Krzysztof Kiser

Hi,

We are using Jira for time tracking, so when someone is working on an issue they would log the time in Jira.
For tracking purposes, we also need to log days off.

We have a dedicated issue type for logging days off with custom start and end date fields.

Is there any way to automatically log work on that issue - 8h for every day between the start and end date (including those dates)?

We are doing this manually now, but would really like to automate if possible.

Accepted answers

All comments

Don Masten_jzyv5k

Do you have Automation for JIRA?
https://marketplace.atlassian.com/apps/1215460/automation-for-jira-server?hosting=datacenter&tab=overview

Krzysztof Kiser

@Don MastenI do and I already looked at it. I don't see an option to log work for days between two dates.

Additionally, I need to be able to make one exception - if the start and end date are the same, only 8h are logged, not 16h.

Don Masten_jzyv5k

@Krzysztof Kiser did you try a cron with a jql? It might be easier to a second rule for your one exception.

bmccoy

Hi @Krzysztof Kiser

You might be able to use the date functions in Automation. The rule might look something like this:

Project automation - Jira 2021-01-14 09-52-38.png

The smart value in the screenshot is:

{{#=}}({{issue.Start Date.diff(issue.End Date).businessDays}}+1)*8{{/}}h

The diff function is not inclusive, that's why I have added + 1 to the result.

Cheers,
Brydie

Krzysztof Kiser

@bmccoythanks for the suggestion.

I tried it, but I am getting an error:


Tried to copy value but fields are incompatible

Date Started : customfield_10409

Could this be because my start date field only includes date without a timestamp?
If so, is there a way to resolve this somehow without adding the timestamp to the field?

And also, I wanted to ask, will this log 8 hours for each day that would be between Start Date and End Date or will it log for example, if the duration is 2 days, 16h for the Start Date?

bmccoy

@Krzysztof Kiser you're right, it's because the start date doesn't have a timestamp. I've raised AUT-2114 to address this (fix on its way)

The formula I have used will get converted into the string "16h", which then gets logged as a single work log starting on the "Start Date".

If you would like to log 8h on each day I think Don is on the right track using a Scheduled trigger. To accommodate not logging twice for a single day I would only run your rule once a day, (the following day the conditions in the JQL would not be met anymore so the rule would not run).

Project automation - Jira 2021-01-19 13-29-40.png

The JQL in that example:

issuetype = Story and "Start date" <= "{{now.jiraDate}}" and "End Date" >= "{{now.jiraDate}}" and resolution = unresolved

Cheers,
Brydie

Radka Svobodova

is there a way to log work as the logAuthor=reporter? because this way the logauthor is jira automation, and than in timesheets it is not assigned to the real user.

Welcome!

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

Quick Links

Find more posts tagged with

server

custom-field

jira-software

jira-software-server

automation

worklog