How to auto populate attributes into Assets custom field using Automation

Summary

This article details steps to automatically populate attribute values of an Assets object into a custom field via Automation for Jira.

Environment

Jira Service Management Assets Cloud Premium

Scenario

The admin would like to update a field in JSM issues with the attribute of the asset selected on the Assets field in the issue. For example, the admin would like to populate the Address custom field with the Location address attribute of the selected Assets object.

Solution

1. Create an Object schema and an Object type for Assets.

2. In the Assets object type, add the Address attribute.

3. On a newly created or existing object, update the Address attribute with a value.

4. Create an Assets custom field and add it to the JSM screen.

5. Add a new text custom field and add it to the same JSM screen. For example, Address.

6. Create the automation:

   • Select the Work item Created trigger (Or any trigger, depending on when/where in the work item you would like the custom field to be updated with the object attribute value).

   • Add the Lookup Objects action.

   • Select the scheme where the object is located, and on Query, use the following insight query language (IQL) to "look" for the object that is selected in the Assets field created in Step 4:

     "Key" = "{{customfield_XXXX}}"
     "customfield_XXXX" being the customfield ID of the Assets field created in Step 4.

   • Add the Edit issue fields action, and edit the Address field created in Step 5 to the following value:

     {{lookupObjects.Address}}
     Address is the object attribute name whose value you would like to populate in the Address Jira custom field.

   • Save and publish the automation rule.