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

JIRA (Data Center) automation - Problem with calculations with values from the changelog

Patrick Schmidt_icr0kr

Hi there,

I'm trying to run a date comparison from two values pulled from the changelog by smart values.

{{changelog.Target end.from}} - Output: 2024-11-15

{{changelog.Target end.to}} - Output: 2024-11-13

I suppose that I will need to convert the output to a date format to do some maths...

{{changelog.Target end.from.toDate("yyyy-MM-dd")}}

...returns something but not the output, which I expected:

Output: Fri Nov 15 00:00:00 CET 2024

First question - Why is that the case?

Second question - Is there a way to do some maths with diff to compare both smart values? Everything I'm trying results in an empty output.

Thanks a lot,

Patrick

Accepted answers

All comments

Bill Sheboy

Hi @Patrick Schmidt

First thing, I am using Jira Cloud and not the Server version (which your post seems to indicate). Please test with your version for the things I am suggesting. Thanks!

When you added the format string of "yyyy-MM-dd" to the toDate() function that helped with the conversion, and the resulting date / time value appears to be returning in whatever your system and profile are using for date / time formats.

Next, the diff() should be possible if all of the values are actually valid date / times. Would you please show your complete rule, and the specifics of where you are performing the diff? And show the audit log details for the rule execution. Those will provide context to help explain what you are observing.

Kind regards,
Bill

Patrick Schmidt_icr0kr

Hi @Bill Sheboy

thanks for taking this up again.

The time format is only specified global. I can't find anything set in addition in my profile.

Here's the rule and all the steps to set variables, mail config and mail output:

Thanks,

Patrick

Bill Sheboy

When you create a variable, that is stored as a text value. Those variables need to be converted to date before using the diff() function.

In your create of the "Diff" variable, that would be this, adding the missing units of measure, days:

One more thing: when creating variables, I suggest adding a prefix to ensure the name is always unique and will not collide with other fields or rule features. For example, consider renaming that variable from Diff to varDiff by adding a prefix of var to symbolize it is a variable.

Patrick Schmidt_icr0kr

Hi @Bill Sheboy

I've got no luck with the new diff variable

{{OldTargetEnd.toDate.diff(NewTargetEnd.toDate)}} doesn't work, neither does

{{#=}}{{OldTargetEnd.toDate.diff(NewTargetEnd.toDate)}}{{/}}

Both result in an empty output and the audit log has no errors.

Same with...

{{OldTargetEnd.toDate("yyyy-MM-dd").diff(NewTargetEnd.toDate("yyyy-MM-dd"))}}

{{#=}}{{OldTargetEnd.toDate("yyyy-MM-dd").diff(NewTargetEnd.toDate("yyyy-MM-dd"))}}{{/}}

Thanks and have a nice weekend,

Patrick

Welcome!

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

Quick Links

Find more posts tagged with

server

jira

jira-software-server