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

Updating calculated number field using automation

Lana Decker_2z6v6v

I need to calculate how many days it was since the risk became actualized Issue.

when Risk becomes the Issue, we set the date "Issue Date"

I need to calculate the number of days between that date and today - and record it in "Days in" scripted field.

I tried to use Edit Issue action and set this field using this script:

{
"fields": {
"Days in": { "value": {{issue.customfield_10803.diff(issue.customfield_10820).days}}
}
}

No bueno! what am I doing wrong?

Accepted answers

All comments

Florian Bonniec

Hi @Lana Decker

Have you try to use the smart value below ?

{{now.diff(issue.created).days}}

Do not use the advancedediting but select the filed in the list and populate the field with the value above.

Reagrds

Lana Decker_2z6v6v

Thank you for your suggestion!

Days in is a scripted field type and its not selectable - so I created another field (number type)

Using {{now.diff(issueID=10821).days}} - I would expect to get number between date field 10821 and today in days - but get no errors, no result

Using {{now.diff(issue.created).days}} - I would expect to get number between that date and today in days - but get no errors, no result.

Automation says success, but the field is empty.

Bill Sheboy

Hi @Lana Decker

Would you please post images of your complete rule and the audit log details showing the rule execution? Those may provide some context for what you are observing, and give the community ideas on what to suggest. Thanks!

Until we see that...

This could be a scoping problem, based on where you are performing that date diff() in the rule. It could also be a timing problem, if the issue you are using was just created.

Kind regards,
Bill

Florian Bonniec

{{now.diff(issueID=10821).days}} is not valid you should use

When you say no result, is that there is nothing displayed or the field is empty when you try to edit it ? Is the field on the view screen ?

Regards

Lana Decker_2z6v6v

Field is on all screens (or a single screen we use for create, edit and view).

I edited query per your suggestion and get this when rule is triggered manually:

Checking any of the "successfully edited" issues i see that field is null in all of them.

Lana Decker_2z6v6v

Made following changes:
change 1.jpg

Result looks like this:

Result 2.jpg

Checking "successful" issues - still empty customfield_10821 (which is a NUMBER field).

(Thank you for your help, Florian)

Lana Decker_2z6v6v

I posted a few - answering questions from Florian, making changes per his suggestions.

To address your points:

This could be a scoping problem, based on where you are performing that date diff() in the rule. - I am trying to set a number field from EDIT action , triggered on schedule (see screenshots).

It could also be a timing problem, if the issue you are using was just created. - no, most tickets are over a week old or older, only one is new.

Welcome!

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

Quick Links

Find more posts tagged with

server

jira-software

jira-software-server

automation

calculated-field