I have been using JIRA project automation to send reminder emails. The body of the email is a table which has a colume to be the difference between created date and now. I have tried multiple combination but none are returning any values in the generated email. there is no error in the audit log either. any pointers will be appreciated. {{created.diff(now).hours}} {{now.diff(issue.created).abs.days}} Pasting the body of the email Total Issue Count :{{issues.size}} List of Issues Issue Key Created Assignee Status Open Duration(days) Open Duration(days) {{#issues}} {{key}} -{{summary}} {{created.format("dd/MM/yyyy")}} {{assignee.displayName}} {{status.name}} {{created.diff(now).hours}} {{now.diff(issue.created).abs.days}} {{/}}

Thanks, @Dileep Kumar Simhadri It seems various functions, when used in smart value parsing, are a bit inconsistent in regarding when the parentheses work / don't work. Sometimes the expressions appear to collapse to null values instead.

Please try now() (with parentheses) and it should work. I tried with the smartvalue: {{sprint.endDate.diff(now()).days.abs}} and it worked.

Hi @[deleted] Yup, at this time those fields and functions are not available within Lookup Issues: * https://codebarrel.atlassian.net/browse/AUT-1996 * https://jira.atlassian.com/browse/JRACLOUD-75018 One work-around for your use case is to use a custom field and scheduled rule to compute the age, and then subscribe to a filter to get the list with the value. We are doing something similar for Age of WIP: https://community.atlassian.com/t5/Automation-discussions/What-is-your-most-useful-automation-Here-is-mine/m-p/1561072#M34 Best regards, Bill

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

smart value for date diff not working

Tushar A.

I have been using JIRA project automation to send reminder emails. The body of the email is a table which has a colume to be the difference between created date and now. I have tried multiple combination but none are returning any values in the generated email. there is no error in the audit log either. any pointers will be appreciated.

<td>{{created.diff(now).hours}}</td>
<td>{{now.diff(issue.created).abs.days}}</td>

Pasting the body of the email

<p><b>Total Issue Count</b>:{{issues.size}}</p>
<b>List of Issues</b>
<table>
<tr>
<th>Issue Key</th>
<th>Created</th>
<th>Assignee</th>
<th>Status</th>
<th>Open Duration(days)</th>
<th>Open Duration(days)</th>
</tr>
{{#issues}}
<tr>
<td><a href="{{toUrl}}">{{key}} -{{summary}} </a></td>
<td>{{created.format("dd/MM/yyyy")}}</td>
<td>{{assignee.displayName}}</td>
<td>{{status.name}}</td>
<td>{{created.diff(now).hours}}</td>
<td>{{now.diff(issue.created).abs.days}}</td>
</tr>
{{/}}
</table>

Accepted answers

All comments

Bill Sheboy

Hi @Tushar A.

When I tried your smart values alone, they worked for me. Although I would add the issue. prefix to reduce confusion for others reading the rule.

Maybe there is a problem with your table mark-up, so try to implement it piece by piece to see what is causing the problem

Best regards,

Bill

Tushar A.

Thanks @Bill Sheboy

I have the other html options works, only one coming blank is this. When i add issue. it does not return any value. this is likely because of {{#issues}} that we have used.

Will keep looking for a resolution.

Bruce MacNeil

Hi, I am also experiencing this issue with the use of the diff function. In the email body:

Results in a rule execution error with the Send Email action:

Error rendering smart-values when executing this rule:
Too many numbers or variables: 2020-04-08 2020-11-12 218

2020-04-08 is the correct created date

2020-11-12 is now

218 days is the correct days difference

Not sure what is causing the error. Any help would be appreciated.

Best regards, Bruce

Bill Sheboy

Hi @Bruce MacNeil -- Welcome to the Atlassian Community!

You are getting that error because you are using the math operations {{#=}} with multiple smart values, but not doing math with the issue values.

If you want to just do that for one issue, drop the {{#=}} and the {{/}}

If you are doing that for a list of issues, such as from Lookup Issues, then instead try something like:

{{#lookupIssues}}
* <a href="{{url}}">{{key}} - {{summary} - Created: {{created}} -- Elapsed days: {{created.diff(now).days}}</a>
{{/}}

Best regards,

Bill

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

addon-com.codebarrel.addons.automation

jira-software-server