How to add two date time custom fields using Jira Automation

Question

I am trying to have total duration after capturing deployment duration and testing duration using this kind of code

{{issue.customfield_27710.diff(now.minusHours(1)).plusMinutes(issue.customfield_27711.diff(now.minusHours(1)).minutes)}}

But this is not working for me can someone please guide me on this

venkatesh_rajput · Answer

Hi @Vamsi Kandala

This worked for me, but I am facing an issue whenever the automation gets trigerred for this first time it is throwing error but it works fine for the same issue when its trigerred for the second time.

Vamsi Kandala · Answer

Hi @venkatesh_rajput

Sorry, I am mistaken earlier.

The keyword 'plusMinutes' is used only for adding the required number of minutes to the given date time value and is not used for calculating the sum of the duration of two date fields.

I have tried this workaround and worked for me.

Create 3 custom fields which are of 'Number Field' data type, called 'Deployment_Duration', 'Testing_Duration' and 'Total_Duration'.

In the automation rule, use the 'Edit issue' action component and assign the following like:

Deployment_Duration = {{issue.customfield_27710.diff(now.minusHours(1)).minutes}}

Testing_Duration = {{issue.customfield_27711.diff(now.minusHours(1)).minutes}}

Total_Duration = {{customfield_xxxxx}} + {{customfield_yyyyy}}

Where 'customfield_xxxxx' is the custom field id for 'Deployment_Duration' and 'customfield_yyyyy' is the custom field id for 'Testing_Duration'

Enclosed the screenshot here for your reference.

Hope this helps.

Thanks,
Vamsi

venkatesh_rajput · Answer

Hi @Vamsi Kandala

I am not getting any error but the values are not appearing it is appearing black, and the customfield_27710 and customefield_27711 are date time picker. Here these two customfields are getting values from other automation at the same time, here is the value for these two custom fields in other automation "{{now.minusHours(1)}}"

Here is the log for that.