Calculate the end time of a worklog

Question

Hi !!

I am creating a rule where I need to calculate the end time of a worklog.

There doesn't seem to be a smart value for this. So I assumed I could create a new variable in my rule and assign it the smart value:

{{worklog.started.plusSeconds({{worklog.timeSpentSeconds}})}}

But this produces the following error:

Unable to render smart values when executing this rule: Failed to get value for worklog.started.plusSeconds({{worklog.timeSpentSeconds: {{worklog.started.plusSeconds({{worklog.timeSpentSeconds}})}}

The strange thing is - is that the error is showing a different smart value than the one I assigned?!

I have tried using asNumber to ensure the worklog.timeSpentSeconds is numeric but that doesn't help either.

Any assistance would be greatly appreciated.

Thanks Sam

Duc Thang TRAN · Accepted Answer

Hello @Sam Brain

Can you try with this  smart value for variable

Wojciech Wardaszko_p20bth · Accepted Answer

Hi @Sam Brain

Welcome to the Community.

One thing: when using Smart values im brackets, you don't add the curly brackets again. It should be {{worklog.started.plusSeconds(worklog.timeSpentSeconds)}}

I hope this helps.

Cheers!