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

Calculating ticket age in email while looping thru issues

Greg Bailey

Hello,

Using Automation for Jira Im creating an escalation email report to be sent for active issues older than 30 days.

The emailed report needs to include the actual ticket age which Im having difficulty calculating using the diff method. I've tried both methods below using smartvalues and neither of them is resulting in the ticket age being included in the emailed report.

Any ideas what Im doing wrong here?

// snippits of email report looping thru issues

{{#issues}}


<tr><td style="border: 1px solid black; padding:5px 10px 5px 5px; ">{{#now}}func=businessDaysBetween({{created}}), format="toDays"{{/}}</td>
</tr>
{{/}}



{{#issues}}

<tr><td style="border: 1px solid black; padding:5px 10px 5px 5px; ">{{now.diff(created).days}}</td></tr>
{{/}}

Any help is appreciated.

Greg

Accepted answers

All comments

Bill Sheboy

Hi @Greg Bailey

Did you already figure this one out? If not, have you tried including the issue prefix to your smart values:

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

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

Best regards,

Bill

Greg Bailey

Hi Bill,
Apologies for the delayed response.

Unfortunately I have not been able to get this to work as expected. I have tried with and without '.issue' in the function.

I tried again this morning to confirm neither works and I was able to show that neither format is working.

Is it possible this is only supported on Jira Cloud and not Jira Server?

Bill Sheboy

Hi Greg,

Would you please post an image of your complete rule? That may provide more context for what is up.

Regarding server versus cloud, there are definite differences in automation. For example, {{#issues}} only works in server for iterating over the result set from a JQL. Cloud needs to use branches or lookupIssues to do that.

Thanks,

Bill

Greg Bailey

Hi Bill,

Below is a screen cap of the rule itself, which is pretty basic and working perfectly other than the date diff calculation.

And here is the HTML, note this has my attempt at using the FUNC method and the diff method neither is working, with and without the 'issue.' present. The diff functions are authored to show up next the actual dates in the table. Any help is surely appreciated.

<br>
<br>
<table style="border: 1px solid black; cellpadding: 5px; ">
<tr style="border: 1px solid black;">
<th style="border: 1px solid black; padding:5px 10px 5px 5px;">Issue</th>
<th style="border: 1px solid black; padding:5px 10px 5px 5px;">Status</th>

<th style="border: 1px solid black; padding:5px 10px 5px 5px;">Assignee</th>
<th style="border: 1px solid black; padding:5px 10px 5px 5px;">Last Updated</th>
<th style="border: 1px solid black; padding:5px 10px 5px 5px;">Requested by Date</th>
<th style="border: 1px solid black; padding:5px 10px 5px 5px;">Committment Date</th>
<th style="border: 1px solid black; padding:5px 10px 5px 5px;">Requesting Business Owner</th>

</tr>

{{#issues}}
<tr style="border: 1px solid black;">
<td style="border: 1px solid black; padding:5px 10px 5px 5px; "><a href="{{toURL}}">{{key}}-{{Summary}} </a></td>
<td style="border: 1px solid black; padding:5px 10px 5px 5px; ">{{status.name}}</td>
<td style="border: 1px solid black; padding:5px 10px 5px 5px; ">{{assignee.name}}</td>
<td style="border: 1px solid black; padding:5px 10px 5px 5px; ">{{updated.format("yyyy-MM-dd")}} ( {{#now}}func=businessDaysBetween({{issue.created}}), format="toDays"}} )</td>

<td style="border: 1px solid black; padding:5px 10px 5px 5px; ">{{customField_12800.format("yyyy-MM-dd")}}({{now.diff(customField_12800).days}})</td>

<td style="border: 1px solid black; padding:5px 10px 5px 5px; ">{{customField_12801.format("yyyy-MM-dd")}}</td>
<td style="border: 1px solid black; padding:5px 10px 5px 5px; ">{{customField_12802.name}}</td>

</td>
</tr>
{{/}}
</table>

Welcome!

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

Quick Links

Find more posts tagged with

server

automation

smart-value