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]

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

[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