Jira Date diff automation

[Sunny Kanojia]

Hi Team,

I used date diff query to automate RCA being recorded and it is giving a success response but the custom field that must be edited is not getting edited.

[Tansu Akdeniz]

Hi @Sunny Kanojia 

Welcome to the community.

Please first check how diff function is used from here: https://support.atlassian.com/cloud-automation/docs/jira-smart-values-date-and-time/

It seems there is something wrong in your usage.

Also, take a look at this existing thread: https://community.atlassian.com/t5/Jira-questions/automation-for-date-difference/qaq-p/2343981

Don't forget to check Audit Logs.

If problem persists, share your formula here in text.

[Bill Sheboy]

Hi @Sunny Kanojia -- Welcome to the Atlassian Community!

Adding to Tansu's answer:

There is definitely an error in what you show for using the diff() function to set the "RCA TAT" field.

Please post the smart value expression you have in that field so the community can offer suggestions.  Thanks!

Kind regards,
Bill

[Sunny Kanojia]

Hi Tansu and Bill,

Thanks for your response. In the RCA TAT, which is a number field, I am trying to capture the difference in hours between two dates, both the events having date and time information. I am getting a success response of the query but the 'RCA TAT' field is still empty.

 The query I am using is :

{{(issue.customfield_10149)diff(issue.customfield_101649.hours}}

[Bill Sheboy]

Please try this update as you had some misplaced parentheses: 

{{issue.customfield_10149.diff(issue.customfield_101649).hours}}

[Sunny Kanojia]

Hi Bill, with the updated query, it is giving the success but automation is making the RCA TAT recorded to none, as before. Please advise.

[Bill Sheboy]

Here are some follow-up questions to try to diagnose this symptom:

1. What type of project is this: company-managed or team-managed?  You may find that at the bottom-left of the screen expanding area.
2. Are those custom fields configured in Jira or from a marketplace addon / app?
3. Have you confirmed with admin functions both of those fields are date / time field types?
4. Have you confirmed those are the correct custom field id values for the fields?
5. Have you confirmed both fields have date / time values when the rule runs?  You may confirm that by writing both values to the audit log before the field is edited in the rule.
6. Have you tried writing the diff() expression to the audit log to check if the expression is correct, but the problem is storing the result: {{issue.customfield_10149.diff(issue.customfield_101649).hours}}

[Harsh]

Hi @Sunny Kanojia 

Can you tell what field type is RCA TAT and what exactly you want. The automation is bit confusing.

Thanks!

[Sunny Kanojia]

Hi Harsh,

Thanks for your response. In the RCA TAT, which is a number field, I am trying to capture the difference in hours between two dates, both the events having date and time information. I am getting a success response of the query but the 'RCA TAT' field is still empty.

 The query I am using is :

{{(issue.customfield_10149)diff(issue.customfield_101649.hours}}

[Harsh]

Hi @Sunny Kanojia 

Instead of directly copying value, you can create a variable first with the smart value to calculate the difference.

And then add that created variable as a smart value {{variablename}} to RSA TAT field.

You can also log action to debug if the smart value mentioned above is actually giving the difference.

Thanks!

[Sunny Kanojia]

Hi Harsh,

Please can you elaborate how can i do this.

[Harsh]

Sure,

Trigger: When issue transitioned 

Condition: Issue type equals 

Action: Create Variable. Lets call it as: datedifference, in smart value put the following: {{#=}} {{issue.date1.diff(issue.date2).days}}{{/}}

{{#=}} implies math formula just for context

Edit Action: Create a log action and put {{datedifference}} to debug if it calculating or not.

Edit Action: Edit Issue: Choose the RSA TAT field, and put the {{datedifference}}.

This should work because I have used the same mechanism several time.

In any case let me know if it works or not.