Calculate the end time of a worklog

[Sam Brain]

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

[Wojciech Wardaszko · Accepted solution]

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!

[Sam Brain]

Perfect - thank you!!

[Duc Thang TRAN · Accepted solution]

Hello @Sam Brain 

Can you try with this  smart value for variable 

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

[Sam Brain]

Perfect - Thank you!!