Automation: send an email with old and new statuses

[Tatiana Marti]

Hello, 

Do you know if it's possible to use automation to send an email with this information:

- last comment

- old status - new status (author of change)

The automation is scheduled, and list issues changed during the week and we want to put in a table the results with thoses informations.

We tried many things but it doesn't work.

Thanks for your help

Clé	Résumé	Responsable	Date de mise à jour	Statut	Commentaire
{{key}}	{{summary}}	{{assignee.displayName}}	{{updated.withLocale("fr").asMediumDateTime}}	{{#changelog.status}}{{fromString}} - {{#changelog.status}}{{toString}}	{{issue.comments.last.body}}

[Dick · Accepted solution]

Hi @Tatiana Marti 

This is very much possible. 

• for last comment: see This Atlassian Page:
  {{issue.comments.last.body}}
• for old status and new status: see This other Atlassian Page:
  old: {{#changelog.status}}{{fromString}}{{/}}
  new: {{#changelog.status}}{{toString}}{{/}}
  

Don't forget to close the list iterations with {{/}}.

I don't think that a value for the last.author.displayname is available on the status change.

Kind regards,

Dick

[Aron Gombas _Midori_]

If you are open to using an app for this, then the Better Excel Automation can generate and email custom Excel spreadsheets.

With a custom template, you can get that exact Excel report you look for. You can find two default templates (samples) ...

1. to export the full change history for an issue set
2. to export all comments for an issue set

You could combine these fairly easily.

(This app is developed by our team.)

[Lucas Modzelewski _Lumo_]

Check this thread: https://community.atlassian.com/t5/Jira-questions/Automation-Changelog-for-Status-Change/qaq-p/2706335

It's from Cloud, but maybe similar approach and insights about triggrs might help