nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Automation to read multiple users from Assets and set them into Approvers field in issue

Jorge_y0jzn5

Context:

We have an assets object type with an attribute (id:1445) Approvers which is of type users and can hold up to 2 names.

We built an automation rule to fetch these names and insert them into the issue Approvers field, taking the object value from the issue {{customfield_54102.key}}.

The component Edit issue fields works fine with the smart value as long as the Assets object contains 1 name, and then, the Approvers field in the issue is properly populated with the name.

Problem:

However, if the Assets object contains 2 names this approach does not work. The names are retrieved from Assets and logged properly, but the automation fail.

log_err (1).jpg

According to the documentation we tried Advanced Editing in may ways like:

{ "fields": { "Approvers": {{lookupAsset.attributeById.1445}} } }

{ "fields": { "Approvers": [ {{#lookupAsset.attributeById.1445}} { "accountId": "{{accountId}}" }{{^last}},{{/last}} {{/lookupAsset.attributeById.1445}} ] } }

Generally, these approaches provide a success in the automation, but the field in the issue still reamins empty.

I'm not able to understand the format comming from Assets. Is it a list of strings? a string representation of a list? How can I parse it to properly fill the Approvers field? Am I missing something else?

Regards

Accepted answers

All comments

Jeroen Poismans

Hi and welcome to the community!

The question is tagged with jira-cloud but the screenshots suggest that you are on server / datacenter. This is important to help you with your questions since the approach differs.

Can you confirm that you are not on Cloud?

Jeroen

Jorge_y0jzn5

my mistake, corrected

Bill Sheboy

Hi @Jorge -- Welcome to the Atlassian Community!

The symptom you are seeing is likely a timing, or racetrack, error in the rule:

the Edit Issue action, when using JSON, can try to parse the JSON before it has been fully evaluated, and
the looking up of the asset data takes time...regardless of how / where it is used in a rule

The solution for this is to force the asset data to be fully resolved before used in the dynamic JSON, by first storing it in a variable:

action: create variable
- name: varUsers
- value:

{{lookupAsset.attributeById.1445.join(",")}}

action: Log the variable to check the values match what is expected
action: edit issue, using the dynamic JSON expression

{
  "update": {
    "Approvers" : [
      {{varUsers.split(",")}}
        { "add": { "name": "{{.}}" } }  {{^last}},{{/}}
      {{/}}
    ]
  }
}

Kind regards,
Bill

Jeroen Poismans

Hi Bill,

Thanks for weighing in. The resolved JSON would be something like this, right:

{
 "update": {
   "Approvers" : [
     {
      "add": { "name": "userA" }
     },
     {
      "add": { "name": "userB" }
     }
   ]
 }
}

When I try this with hardcoded usernames (without the list iteration smartvalues), the error that OP describes remains. So not sure that the fetching is the issue here. Any thoughts on this?

Jeroen

Jorge_y0jzn5

Hi Bill,

Thanks for the answer. Holding the value in a variable is a nice idea. After implementing your proposal I started getting the following error:

XAASP-3370 (Could not find usernames: a***k.j***t (customfield_50000))

After a search, I found this KB. The customfield_50000 (Approvers) is a user picker field. I tried to display the name in another variable with the format described in the KB note (just for log, not updating the field):

{{#lookupAsset.attributeById.1445}}[~{{name}}]{{^last}},{{/}}{{/}}

[~{{lookupAsset.attributeById.1445.name}}]

I did this with 1 or 2 names coming from Assets. The first variable varUsers displays the content but it is not recognized by the content picker.

rule_formatted (1).jpg

{
  "update": {
    "Approvers" : [
      {{#varUsers.split(",")}}
        { "add": { "name": "{{.}}" } } {{^last}},{{/}}
      {{/}}
    ]
  }
}

Could the simplified Edit Issue Fields component have an intermediate step under the hood to convert the user that I need to implement?

Bill Sheboy

Hi @Jeroen Poismans -- Yes, that is correct on the results of the dynamic JSON expression. My understanding was Server / Data Center used the user name in this case. Did you try that hardcoded example with Server / Data Center?

Hi @Jorge -- In the audit log you show, it appears there is a comma-followed-by-a-space delimiter between the names, and not a comma only. That would then not work with the JSON expression I showed.

Please post an image of the action where you create the variable varUsers to help confirm that. There may be extra spacing in the object attribute that needs to be removed with the trim() function.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

jira-server

automation

assets