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; } } }

Calculate difference on worklog edit

Kevin Grey

Hi, is it possible to access the previous values of a worklog when someone edits them using the automation trigger "Work Logged". I am trying to pass the values on and for an edit I need to know that a user has changed from 2h down to 1h so that I can calculate this difference and send it to a downstream service.

I have tried logging the "{{changelog}}" but receive this "ChangeLogList{startAt=0, maxResults=0, total=0, histories=null}"

Also "{{#changelog.timeSpentSeconds}}{{fromString}} - {{toString}}{{/changelog.timeSpentSeconds}}" doesnt work.

Is it possible to achieve this?

Accepted answers

Kevin Grey

I created separate rules for CREATE, UPDATE and DELETE worklogs. CREATE and DELETE was easy to handle as that just adds or subtracts, the logic for UPDATE was a bit more complex and brittle.

Screen Shot 2022-05-04 at 1.19.06 PM.png

I ended up using the changelog from the API. It relies on the last value in there being the worklog that triggered the automation. This would have been a lot simpler if I had access to the changelog from a worklog triggered action

All comments

Stefan Salzl

Hi @Kevin Grey

I´m not getting the use case right now. Could you please further describe "from 2h down to 1h"? As far as I know the log work is just adding time to your work log. Or do you mean the the "Original estimate" field?

Best
Stefan

Kevin Grey

Screen Shot 2022-05-03 at 11.21.24 AM.png

Example automation above. This works fine for sending newly created work logs, however when a user edits them I would like to know the before and after values. Currently I can only access the "after value"

Screen Shot 2022-05-03 at 11.25.18 AM.png

Stefan Salzl

Hi @Kevin Grey

Couldn´t figure out how to do this out of the box.

Without knowing what you are trying to solve with it one way would be to calculate with the values you´ve got:

From the event you can get the amount of time that is added and the current spent time can be retreived from the issue. Subtracting the time added from time spent will give you the initial value.

Best
Stefan

Kevin Grey

I considered this but if multiple people are logging against the ticket or if there are multiple logs from the same person then it would be difficult to calculate as I would also have to get all worklogs associated to that ticket and caluclate the total from them and then compare to the issue (whilst hoping that no-one has submitted another log in the meantime)

Kevin Grey

I created separate rules for CREATE, UPDATE and DELETE worklogs. CREATE and DELETE was easy to handle as that just adds or subtracts, the logic for UPDATE was a bit more complex and brittle.

Screen Shot 2022-05-04 at 1.19.06 PM.png

Welcome!

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

Quick Links

Find more posts tagged with

cloud

jira-software

jira-software-cloud

automation