Automated report where last comment was by reporter

Question

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_7nagel · Answer

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_0av1h6 · Answer

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.