Using JQL to search the last comment on an issue and trigger a result.

[Liam]

I am trying to have a notification be sent via slack if a specific user is mentioned in the most recent comment on a Jira Issue. 

I feel like this is doable via JQL, but for some reason I can't seem to get the syntax right:

• {{issue.comments.last.body}} ~ accountID

(The accountID variable is just the account ID of the specific user in jira)

I've confirmed that {{issue.comments.last.body}} is a valid smart value that does in fact pull the last comment that was placed on an issue, but for some reason I can't get criteria to be met so that a message is only sent when the accountID appears in the last comment.

Any assistance would be greatly appreciated, also if any clarification is needed please let me know.

[Vamsi Kandala · Accepted solution]

Hi @Liam

Here is an alternative solution in your case:

https://community.atlassian.com/t5/Marketplace-Apps-Integrations/How-to-display-Last-comment-in-Filter-JQL-and-any-Add-on/ba-p/1489153

Hope this helps.

Thanks,
Vamsi

[Liam]

Thank you for this! i was able to get a work around setup where the Last Comment was updated in a new field and then filtered off that field

[Vamsi Kandala]

Hi @Liam

If I am not wrong, you can't be using '{{issue.comments.last.body}}' within the JQL query.  Besides, currently the JQL query only supports 'comment ~ accountID' and does not yet support @mentions in the comments.

Please refer to this ticket: https://jira.atlassian.com/browse/JRACLOUD-27594

Thanks,
Vamsi