Copy comment author into custom userpicker field - Automation for Jira

Jason Thompson January 27, 2021

Hello,

I am looking for help using Automation for JIRA to copy the author from the last ticket comment into a custom (user Picker) field, when a ticket is commented on.
As shown below in the screenshot. (In this instance, I manually edited the field)

The reason is, I would like to be able to setup a JQL filter, to filter the last comment author against the tickets assignee. 

overview.png

I have setup the custom field 'Last Commented User' customFieldId=10603

and the Automation for JIRA rule looks like this.

rule.png

The rule failed error messages look like this.

audit.png
Can anyone provide any advice?

Thanks ...

F.Y.I, we are running the below (server) versions ...

JIRA Service Desk 3.16.0
Jira Software 7.13.0
Jira Core 7.13.0
Automation for Jira 7.2.3

1 answer

1 accepted

1 vote
Answer accepted
Bill Sheboy
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
March 18, 2021

Hi @Jason Thompson 

Have you already solved this question?  If not, I wondered about two things:

  • Have you confirmed the custom field ID you are using matches that field name?  Your admin can check that, or you can use this how-to when you need the smart value name for a field: https://support.atlassian.com/jira-software-cloud/docs/find-the-smart-value-for-a-field/
  • Next, in your JSON to edit the custome field, it appears that you are trying to set a display name to an account ID.  That does not appear to be what you described wanting to do: set the custom user field to the last commentor.


Best regards,

Bill

Jason Thompson March 22, 2021

Hello Bill,

Thank you very much for the reply and advice.
No I have not managed to get this working yet ...

I am fairly sure I have the correct field ID, see image below.

2021-03-22 14_33_14-Configure Custom Field_ Last Commented User - Jira.png
Regarding editing the JSON, well I guess this is where I really need the help.
The JSON I was using i cobbled together from various forum posts with the similar problem, as well the Atlassian Smart Value guides like the one you linked.

I have edited the JSON as below...

2021-03-22 14_33_55-Project automation - Jira.png

However I still get the same error message ...

2021-03-22 14_43_20-Project automation - Jira error message.png

You said in your post "set the custom user field to the last commentor".
I suppose that is where I get stuck. How do I do that?

Thanks in advance.

Like manel_benamor-extern likes this
Bill Sheboy
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
March 22, 2021

Hi Jason,

You appear to be setting a user field with just the display name.  Have you tried to set the last commentor's user to the custom field?  And, check that comments is plural for the smart value.

{
"fields": {
"customfield_10603": "{{issue.comments.last.author}}"
}
}
Jason Thompson August 6, 2021

@Bill Sheboy 

Thanks for your help with this problem.

Using information from this post and ...

Is there a way to see on the queue who was last to comment/update the ticket

Automation Condition - compare lastCommentAuthor = Customer (or participants)

... I have been able to solve the issue.

Once again, thanks for your help :) 

Like # people like this
Ashraf B January 26, 2022

Hi @Jason Thompson@Bill Sheboy 

I have created a CustomField "Latest Comment By" of "User picker (single user)" type and am trying to populate it using an Automation rule at "Issue commented" event


Can you share the script, if possible...

Additionally, I am also trying to populate Latest Comment Date, but am still working on it (Field type, etc.)...

Thanks and regards,

Ashraf B

Bill Sheboy
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
January 26, 2022

Hi @Ashraf B 

Please try by accessing the value for your custom field, such as the following (filling in your own custom field name):

{{issue.myCustomFieldName.value.displayName}}

Smart values for custom fields are not always obvious, so if you cannot get it to work please the information in this how-to article to identify your custom field's smart value:

https://support.atlassian.com/cloud-automation/docs/find-the-smart-value-for-a-field/

For the last comment added date, please try this:

{{issue.comments.last.created}}

 

Kind regards,
Bill

Ashraf B January 26, 2022

Sure @Bill Sheboy ,

Thanks again,

Best regards,

Ashraf

Like Bill Sheboy likes this

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events