Context, on a ticket, i have : * an issue date field * a date automatically set when I transit a ticket into the blocked externally column What I want to do : calculate the new issue date when the ticket comes back to the "in progress" column For example : * issue date = 15/08/2024 * start of externally blocked = 09/08/2024 ("issue.customfield_10246") On the 18/08/2024 I move back the ticket into the "In progress" column, the new issue date should then be 25/08/2024 (Now + (15/08 - 09/08) = 25/08) You follow me ? I'm new to smart value and SQL function so I tried something exotic but it doesn't work : {{now.plusDays(duedate.diff(issue.customfield_10246.toDate).businessDays}} Anyone figuring this out here ? Thanks you so much in advance

Hi @Eric Brandenburg Welcome to the community. The diff smart value option is for calculation between date, the output will be a number no a date, as its a calculation. toDate smart value option is only able to convert text information to a date, and that text needs to be in the correct format So what could be done is that you: * calculate the number of difference, store this in a field in Jira * re-fetch the issue data * then edit the issue date now plus the number of days in difference, it might be that you need to store the value form the number field in a variable before you can use it in the calculation

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

automation for jira using smart value: plusDays using diff doesn't work

Eric Brandenburg

Context, on a ticket, i have :

an issue date field
a date automatically set when I transit a ticket into the blocked externally column

What I want to do : calculate the new issue date when the ticket comes back to the "in progress" column

For example :

issue date = 15/08/2024
start of externally blocked = 09/08/2024 ("issue.customfield_10246")

On the 18/08/2024 I move back the ticket into the "In progress" column, the new issue date should then be 25/08/2024 (Now + (15/08 - 09/08) = 25/08)
You follow me ?

I'm new to smart value and SQL function so I tried something exotic but it doesn't work :

{{now.plusDays(duedate.diff(issue.customfield_10246.toDate).businessDays}}

Anyone figuring this out here ?

Thanks you so much in advance

Accepted answers

Marc -Devoteam-

Hi @Eric Brandenburg

Welcome to the community.

The diff smart value option is for calculation between date, the output will be a number no a date, as its a calculation.

toDate smart value option is only able to convert text information to a date, and that text needs to be in the correct format

So what could be done is that you:

calculate the number of difference, store this in a field in Jira
re-fetch the issue data
then edit the issue date now plus the number of days in difference, it might be that you need to store the value form the number field in a variable before you can use it in the calculation

All comments

Marc -Devoteam-

Hi @Eric Brandenburg

Welcome to the community.

The diff smart value option is for calculation between date, the output will be a number no a date, as its a calculation.

toDate smart value option is only able to convert text information to a date, and that text needs to be in the correct format

So what could be done is that you:

calculate the number of difference, store this in a field in Jira
re-fetch the issue data
then edit the issue date now plus the number of days in difference, it might be that you need to store the value form the number field in a variable before you can use it in the calculation

Bill Sheboy

Hi @Eric Brandenburg -- Welcome to the Atlassian Community!

For a question like this, please post an image of your complete automation rule, images of any relevant actions / conditions / branches, an image of the audit log details showing the rule execution, and explain what is not working as expected. Those will provide context for the community to offer ideas. Thanks!

Until we see those...

Assuming your customfield_10246 is text, the expression you show is missing a closing parenthesis at the end:

{{now.plusDays(issue.duedate.diff(issue.customfield_10246.toDate).businessDays)}}

If instead your customfield_10246 is a date or date / time field, the toDate conversion may be removed:

{{now.plusDays(issue.duedate.diff(issue.customfield_10246).businessDays)}}

Kind regards,
Bill

Eric Brandenburg

Thanks to both of you, I got a "success" on that automation but the result is not the one expected.

My custom field is already a date fiel so it works fine as it is without the "toDate".

{{now.plusDays(issue.duedate.diff(issue.customfield_10246).businessDays)}}

which in calculation should look like that : 

{{14/08.plusDays(issue.15/08.diff(issue.12/08).businessDays)}}

But the calculation went wrong :
I had :
due date = 15/08
start of blocked ticket = 12/08 (my customfield_10246)
So the result expected when putting the ticket back in the "in progress" column was due date = 17/08 but I got due date = 11/08 instead

Screenshot 2024-08-14 at 11.27.23.png

Eric Brandenburg

Thanks @Bill Sheboy and sorry for the missing screenshot. See my answer to marc below if you can help
Thanks again

Marc -Devoteam-

Hi @Eric Brandenburg

First try

{{issue.duedate.diff(issue.customfield_10246).businessDays}}

What is the outcome?

Eric Brandenburg

Ok, I wanted to do it all in one formula but let's go step by step as you suggest, maybe easier.
So I created this automation rule :

--> that works, success, and gives me the number of BusinessDays the ticket spent in the externally blocked column (customfield_10246)

Screenshot 2024-08-14 at 14.47.57.png

I then added a second rule (screenshot below) to add that number to the due date, it says success but I lost the value in the duedate field, it's now blank so it didn't work :

Screenshot 2024-08-14 at 14.48.33.png

result on the ticket :

Screenshot 2024-08-14 at 14.51.45.png

Any idea on this one ? This one should have been easy, no ?

Welcome!

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

Quick Links

Find more posts tagged with

jira

cloud

jira-cloud

automation

diff

smart-value

dates