Troubleshooting Jira Automation Rule for Date Calculation with Review Frequency

[Abdur Rehman]

Hi @Stefan Salzl 

I am currently working with an object in the IT Infrastructure schema, and I’m trying to update the "Next Periodic Review Date" by adding the "Review Frequency" (integer) to the "Last Periodic Review" (date) field.

I have configured the rule as follows and reviewed the audit logs:

{{object.Last Periodic Review Date.plusYears(object.Review Frequency).format("MM/dd/yyyy")}}

The rule successfully retrieves the correct object when triggered, and the values are fetched correctly. However, when using this rule, it returns NULL for the "Next Periodic Review Date". When I manually input plusYears(4) instead of plusYears(object.Review Frequency), it works as expected

Could you kindly suggest what might be causing this issue with the smart value?

Thank you in advance for your help

[Bill Sheboy]

Hi @Abdur Rehman -- Welcome to the Atlassian Community!

When using the Lookup Objects action, that loads the results in this smart value:

{{lookupObjects}}

Followed by the attributes needed.  Did you intend to use the results of the lookup in one of the later rule steps, such as the plusYears() function call?

Kind regards,
Bill