Populate Work Item Custom Assets Field with Attribute from Another Work Item Custom Assets Field

[Nicolas Rigaill]

Hello everyone,

I am having trouble synchronizing two "Asset" fields via automation, similar to these topics:

• https://community.atlassian.com/forums/Jira-Service-Management/Populate-Assets-Field-with-Attribute-from-Another-Asset-Field/qaq-p/2961528
• https://community.atlassian.com/forums/Jira-Service-Management/How-to-use-automation-to-populate-Assets-custom-field-with/qaq-p/2544628

My need: When a user selects an object in an "Application" Asset field, I want the "Squad" Asset field to be automatically updated with the values contained in the attribute of the selected application.

My configuration:

• Schema A (Applications): Contains an "Object" type attribute pointing to Schema B.

• Schema B (Squad): List of teams.

• Jira Ticket: Has two Asset fields: Application and Squad.

The problem: The automation works for Text or User fields, but fails for the Asset field. I am using the following logic:

• Log action: squads: {{issue.Application.Squad Owner}}

• Log result: squads: [IT-6640, IT-6641] (The IDs are correctly retrieved).

• Edit Issue field (Squads): via AQL: Name LIKE {{issue.Application.Squad Owner}}

The error received: "Bad Request: No fields or field values to edit for work items / Unable to retrieve the CMDB."

It seems that the format of the list of IDs returned by smart values is not accepted by the destination field's AQL.

How can I correctly format the value or the AQL so that the "Squads" field accepts these multiple objects?

Thank you for your help!

[Marc -Devoteam-]

Hi @Nicolas Rigaill 

What if you in the edit action set: Key in ({{issue.Application.Squad Owner}})