Keep Logged Time in CustomField

[Gor Greyan]

Hi Dear Community!

I need a solution in this case.

I have a custom field named Logged in Current sprint.
I need an automation, which will copy logged time in the mentioned customfield, but logged time only for the current sprint, no need to copy all logged time, which could be transferred from previous sprint.

{
"fields": {
"customfield_23826": "{{#=}} {{issue.fields.timetracking.timeSpentSeconds}} / 3600 {{/}}h"
}
}

I used this, but it returns all logged time, I need only the logged time of the current sprint of the each ticket to keep in the customfield.

[Marc - Devoteam]

Hi @Gor Greyan 

This can't be done.

Log worked actions can't be differentiated based on Sprint field value is populated or not.

So Time Spent only has information based on the logged work.

[Gor Greyan]

Hi @Marc - Devoteam
Thanks for the response.

So, you mean that from the Time Spent, there is no possibility to get information and keep it in customfields, that are logged in the current sprint?

[Marc - Devoteam]

HI @Gor Greyan 

Correct.

Logged time is on an issue, when this occurred can be filtered based on dat, but not related to a Sprint name

[Stefan Salzl]

Hi @Gor Greyan 

I could just think of a workaround with a separate customfield and some automation:

• 1 automation rule that adds logged time to that special customfield
• another automation rule that clears the field whenever a new sprint was started/is added to the issue

Might that be a feasible solution for you?

Best
Stefan

[Gor Greyan]

Hi @Stefan Salzl
Thanks for the answer.

But how to copy the logged time into that custom field? I tried my mentioned way, but it copied all time logged time.

[Stefan Salzl]

Hi @Gor Greyan 

I just did a quick test rule and as far as I got you right it does the job.

The trigger is a "work logged" trigger with "work log created" action:

This means it will run whenever a new working time is logged. The trigger allows to get the amount of time logged with the smart value {{worklog.timeSpentSeconds}}

Afterwards I add the amount of logged time to my number field (see screenshot):

The whole calculation statement within the edit issue action is:

{{#=}} {{issue.Number 1|0}} + {{worklog.timeSpentSeconds.asNumber}}{{/}}

In case your users are allowed to delete their worklogs you could create another similar rule with the same trigger but with "delete" action and then substract the time logged.

Furthermore another rule needs to be created that "resets" all issue´s number field when a sprint is closed so that you start from scratch in the new sprint.

Hope this gives some hints and input to solve your requirement.

Best
Stefan

[Iryna Komarnitska_SaaSJet_]

Hi @Gor Greyan ,

Our app, Time in Status by SaaSJet, currently cannot populate a custom field with logged time filtered by sprint. However, we do provide this data within the Sprint Report, where it’s calculated like this:

Logged Time – The total time team members spent on each work item during the sprint, based on worklog records between the sprint’s start and completion dates.

So, while you can’t push this data into a custom field at the moment, you can still view the precise sprint-based logged time through our app’s Sprint Report section.

[Gor Greyan]

Hi @Iryna Komarnitska_SaaSJet_

Thanks for the provided solution. 
But does it provide information per ticket?
I need this at the ticket level