Automated report where last comment was by reporter

[Mark Cartwright]

Hello,

I'm looking for some help to automate a mail that will send a list of tickets where the last comment was made by the reporter.

The contents of the mail are fine, it's the logic of the queries I'm struggling with.

Does anyone have any suggestions please?

Many thanks,
Mark

[Gareth Cantrell]

Hi @Mark Cartwright 

Jira does not support these types of query out the box. 

If you’re using Jira Data Center or Server and have ScriptRunner installed, it has a custom JQL function that does just this (lastComment() ).

There is no equivalent on Jira Cloud to my knowledge. 

[Gaurav]

Hello @Mark Cartwright 

For this, you can create an automation with the condition as shown in the below screenshot.

{{issue.comments.author.displayName}} equals {{issue.reporter.displayName}}

OR

{{comments.author.displayName}} equals {{reporter.displayName}}

For more details on smart values, please refer to the Atlassian documentation here.

Please accept the answer if this helps solve your query else respond and allow others to share input.