Need automation to update a field with a comment and get the DisplayName, not ID of a mention?

[Cash Coyne]

How can I use automation to update a field with a comment and get the text name, not ID of someone mentioned in the comment using the "@" function to reference someone.  I'm not talking about the person making the comment, I'm talking about a person (or persons) who was mentioned in the body of the comment

I have an Automation Rule which populates a Custom Field called LastComment with the msart value of {{issue.comments.last}}. 

This works fine, except that when someone is mentioned in the comment, it shows up something like this: [~accountid:70121:76e8071e-e445-4674-b7a3-e17c64eb6757] in my custom field LastComment

Is there a way that I can get that mentioned person to have their name shown, not their ID?

[Alex Koxaras _Relational_ · Accepted solution]

Hi @Cash Coyne 

Can you try {{issue.comments.body.last}} on your field and let me know the outcome? I've tried it on my instance and the result I have is to copy the last comment exactly as is. I mean e.g.:

Comment: "Hi @Cash Coyne please check this out!"

Then using the  {{issue.comments.body.last}} on a multi line text field will be the exact same text/comment: "Hi @Cash Coyne please check this out!"

What type is your field? Text?

[Alex Koxaras _Relational_]

And another thing you could do is to get the person's id from a smart value, using the following {{issue.comments.last.body.substringBetween("[~accountid:","]")}}, and use it on a user field. Then re-fetch the data and then copying  the new user field onto your text field. But this would increase the processing time of your rule to approximately 4-5 secs. Which is a lot.

[Cash Coyne]

That worked.  THanks @Alex Koxaras _Relational_ !

[Alex Koxaras _Relational_]

Good to know that!

[Vamsi Kandala]

Hi @Cash Coyne

Please refer to this post where a workaround was mentioned.

https://community.atlassian.com/t5/Jira-Software-questions/Jira-Cloud-Automation-how-can-I-get-a-user-name-from-accountid/qaq-p/1467698

Hope this helps.

Thanks,
Vamsi